I have a workbook which creates and inserts additional sheets, based o
a list of items located elsewhere. The number is items in the lis
varies, but I would like the workbook to handle as many as possible.
Then, the macro pastes identical info onto each of the newly create
sheets. On each sheet then, there is about 750 rows and 20 columns o
data. The macro is designed to create, then paste, then create...

The problem I have, is that after around 75 sheets, the workbook slam
to a halt during the sheet creation process. I have found it seem
faster to select and paste entire columns, versus ranges of data
although the ranges are smaller.

Can anyone suggest any methods or changes I could make to speed thi
process up?

It also seems as though Excel doesn't always reset the worksheet coun
if I delete the sheets and start over. For instance, if it creates 9
sheets and I delete them, the next time it starts creating them, it ma
beging numbering them at 96.

Thanks for the help, sorry for the novel

--
Paul98
-----------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...fo&userid=2485
View this thread: http://www.excelforum.com/showthread.php?threadid=38935