I have written the following test program which does not work. Does
anyone know why it doesn't? I want to copy a column from one workbook
and paste it into another. I am now getting desperate as this is
holding up work. Here is the code:
Sub CopyPaste()
Workbooks("Automation Test.xls").Activate
Worksheets("Sheet1").Activate
Range("E2:E65000").Select
Selection.Copy
Workbooks("ABNLookup.xls").Activate
Worksheets("ABNLookup").Activate 'THIS IS WHERE IT CRASHES
Range("A4").Select
End Sub
When I try to execute the line 'Worksheets("ABNLookup").Activate' it
crashes with 'Runtime Error 9 Subscript out of range'. Please help.
Bookmarks