Not in this situation... there are 23 sheets. I've inserted
For..Each code to go through the sheets and tell me numbers and
names.. that works.
I've also tried adding at the end and get the same result.
The strange thing is that after opening the workbook I can run the
main code 2 time with no problems but the 3rd time it always fails on
the copy. That subroutine I gave is actually run a number of times
during the "main" code... Also... after the code "stops working" then
I can't even do a wo/man-aul ( :-) ) copy either! I go through the
motions and get no error but no extra sheet either! Then I have to
close excel down and open up again and everything works.