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,
|