Thread: Excel VBA error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Money[_2_] Money[_2_] is offline
external usenet poster
 
Posts: 1
Default Excel VBA error

I have the need to programmatically create up to 100
worksheets in a workbook. I have run into a limitation
that hopefully has an answer. After about 20 to 30 copy
before comands, if bombs. I can save my changes exit
excel reopen and continue to add worksheets. It appears
there is a cache or memory buffer that i will have to
clear after 20 worksheet copies before continuing but have
been unsucessful thus far. Help.

Thanks,