ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copying Sheet (https://www.excelbanter.com/excel-programming/273603-copying-sheet.html)

Jim[_19_]

Copying Sheet
 
I am copying a sheet. I have re-named my sheet shtSample.
Here is the exact code.

shtSample.Copy Befo=shtSample

It works in my spreadsheet 42 times and always dies on
the 43rd. It is always being called in the exact same way
from the exact same function. I have tried just before
the code executes on the 43rd time to add the sheet in
manually and I can not even do that.



All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com