| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Code Execution Excel XP Vs Excel Office 2000
An application I have written runs in seconds in Excel
2000 but takes minutes using Excel 2002 the offending code is the ActiveCell.EntireRow.Delete statement in the code subset listed below. One by one rows are deleted taking lots of time (XP) -- same code same everything Office 2000 - instantly. Any ideas are welcome. Thanks Do If ActiveCell.Value = "Delete" Then ActiveCell.EntireRow.Delete Else ActiveCell.Offset(1, 0).Select End If Loop Until ActiveCell.Value = "" Or ActiveCell.Row 1000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening an Office 2003 Excel doc with Office 2000 NT | Excel Discussion (Misc queries) | |||
| Help - VBA Code execution in Excel | New Users to Excel | |||
| Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
| I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
| Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) | |||
Threaded Mode
