ExcelBanter - copy method of object failing

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - copy method of object failing (https://www.excelbanter.com/excel-programming/359328-copy-method-object-failing.html)

vj2india

copy method of object failing

When I copy I have written some code in VBA which copies sheets from one open
workbook(of a some 10 odd MB) into another document. WHether I use move or
copy, after a point it begins to fail. It might work one time but the next
time it doesnt..

All times are GMT +1. The time now is 03:00 PM.