Hey everyone in part of my macro I have it select the data to be copied. Currently I am using a range but was wondering what I could use to select all instead. Code is below~
Code:
Workbooks.Add
Workbooks.Open Filename:=ThisWorkbook.Path & "\Bond.csv"
[B] Range("A1:IV2000").Copy[/B]
Windows("Book1").Activate
ActiveSheet.Paste