Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some very simple code:
With Workbooks("Barcoded_Inv_2007_07.xlsm").Sheets("Raw _Data") ..Range("A3:AA50000").ClearContents End With This code has been running over ten minutes and has maxed out the processor. Ctrl-break will not stop it. Automatic calculation is turned off. There is data in A3:AA:XXXXX I just need to erase all the formulas and values in that range so I can write new data there. Thanks, Brent |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
how do i add time to see how long my macro takes to run | Excel Programming | |||
Excel Help takes a very long time to load | Excel Discussion (Misc queries) | |||
Save takes long time | Excel Discussion (Misc queries) | |||
Saving Takes long time | Excel Programming |