I'm trying to copy some cells from one worksheet and paste them in another worksheet in another workbook. But I get the error message :-
Run-time error -2147417848 (80010108)
Method 'Paste of object '_Worksheet' failed.
The code I'm using is :-
This is very similar to a method I'm using elsewhere but this doesn't seem to work.
In fact Copy and Paste in VBA seems to me to be very 'Hit and Miss'. So, as well as a fix to this particular problem, I would be interested in general guidelines.
Run-time error -2147417848 (80010108)
Method 'Paste of object '_Worksheet' failed.
The code I'm using is :-
Code:
FilePath = ActiveWorkbook.Path & "\Spirit Supply Reports.xls"
Workbooks.Open Filename:=FilePath
Workbooks("Spirit Supply Scheduler.xls").Activate
Worksheets("Parameters").Range(Cells(1, 1), Cells(3, 2)).Copy
Workbooks("Spirit Supply Reports.xls").Activate
Worksheets("Parameters").Activate
Cells(1, 1).Activate
ActiveSheet.Paste
This is very similar to a method I'm using elsewhere but this doesn't seem to work.
In fact Copy and Paste in VBA seems to me to be very 'Hit and Miss'. So, as well as a fix to this particular problem, I would be interested in general guidelines.