Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lucas Ward   on Jan 01 In MS Office Category.

  
Question Answered By: Andrew Levensky   on Jan 01

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.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Excel 2000 - Copy Sheet Or get search suggestion and latest updates.


Tagged: