View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cheddar cheddar is offline
external usenet poster
 
Posts: 2
Default a macro problem with a lot of sheets in a book.

Using Excel 2003, I download a file then run a macro to
create a multi-sheet book.
My macro aborts at 58 sheets(each sheet is 20 rows X 5
columns). It's not data related because I clipped out some
of the beginning data, and it continues until it hits 58.
I can merge 2 books and end up 100 sheet book(the final
desired result).

Anyone with suggestions?