Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any way to speed this up?
Hi
I've got a bit of code that scans through each cell in the first column of a spreadsheet using the offset method looking for pagebreaks, and inserting a new line and some text if it finds one. It takes about 20secs to do just 200 rows. I've set application.visible to false and application.screenupdating to false. Does anyone know of a way i can speed this process up? Thanks Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you speed UP drag speed? | Excel Discussion (Misc queries) | |||
I need mor Speed!!!! | Excel Discussion (Misc queries) | |||
Speed | Excel Programming | |||
need for speed! | Excel Programming | |||
Speed? | Excel Programming |