Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is anybody else experiencing huge delys with the the .Clear method?
and more importantly, are there any magical tips for it? Let's take an example: Range("Sheet2!C10:C40000").Clear takes 1minute 54 seconds(yes, i timed it with a stopwatch). This is an average of 3 trials, each of which took a similar amount of time. True this is running on a laptop with a Centrino Duo (2x 1.06 GHz processors) and with excel only ever using one of these, it doesn't help. The same code on a laptop running excel 2003 (single 1.3 GHz processor) is almost instant, a few seconds at most. I don't really expect anybody to come up with something to solve this, but rather to tell me that there is a problem with excel? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clear excess formats in Excel 2007 | Excel Worksheet Functions | |||
slow to open Excel 2007 and Word 2007 (MIS stumped) | Excel Discussion (Misc queries) | |||
Clear All in 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 slow | Excel Programming | |||
Any thoughts - VBA Slow Down with Range.Clear Command | Excel Programming |