Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel seems to become lethargic
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 |