Thread
:
Is there any way to speed this up?
View Single Post
#
6
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Is there any way to speed this up?
Post your code
--
Don Guillett
SalesAid Software
"Keith74" wrote in message
ups.com...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett