L
Lee Michels
I recorded a simple macro to copy a worksheet to the same workbook
multiple times. I want to be able to copy the worksheet up to 100
times. The loop works fine but fails at different intervals (mostly
after 39 successful copies. I get the 1004 Copy method of worksheet
fails. Why does it work fine then fail? Also why does it fail at
different times? Anyone that could shed some light on this one? I run
MS Office 2000 on MS XP.
*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****
multiple times. I want to be able to copy the worksheet up to 100
times. The loop works fine but fails at different intervals (mostly
after 39 successful copies. I get the 1004 Copy method of worksheet
fails. Why does it work fine then fail? Also why does it fail at
different times? Anyone that could shed some light on this one? I run
MS Office 2000 on MS XP.
*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****