Hi,
I have written the code below to copy a range from a saved workbook and to paste it into the active workbook that the project is saved in:
It works perfectly but I need to select another range from the same saved workbook so I re-wrote the code as follows:
When I run this code I get the error message:
Run-time error '-2147221080 (80040198)':
Method 'sheets' of object '_workbook' failed
The line "Wb1.Sheets(1).Range("L1:L10").Copy' is highlighted in yellow when I go to de-bug.
Can anyone tell me where I am going wrong please?
Thanks very much in advance
Michael
Bookmarks