Thread: Copying Sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim[_19_] Jim[_19_] is offline
external usenet poster
 
Posts: 1
Default 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.