| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting & Deleting rows can take ages in Excel 2000
I have created an Excel application for Engineering Quality Document (FMEAs). These documents have: lots of merged cells, no more than 20 columns generally less than 200 rows. In Excel 97 the application ran fast enough not to be annoying. The same code in Excel 2000... well you have many forced coffee break waiting for it! (Some functions can take 20mins on a Pentium 3, 1GH with 256Mb Ram, which used to run in less than 1 min) I have looked at the code in great detail and have discovered that 99 + of the time, the code is waiting for Excel to insert or delete row. I use the very basic lines of code: Cells(x,y).EntireRow.Delete Cells(x,y).EntireRow.Insert Is there anything that can be done to speed this up ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting and Deleting Rows in Excel | Excel Worksheet Functions | |||
| Speed of Excel When Inserting & Deleting Rows | Excel Discussion (Misc queries) | |||
| inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
| Excel links & inserting/deleting rows | Excel Discussion (Misc queries) | |||
| Updating, Deleting and inserting rows over two Excel Sheets | Excel Worksheet Functions | |||
Threaded Mode
