I run the following code at the start of my program and it takes unbelievably long (about 1 minute). Anyway to do the below much faster? Thanks.
Thanks so much.
Please Login or Register to view this content.
I run the following code at the start of my program and it takes unbelievably long (about 1 minute). Anyway to do the below much faster? Thanks.
Thanks so much.
Please Login or Register to view this content.
Last edited by Leith Ross; 12-14-2007 at 12:15 PM.
You must use Code tags when posting code!
Your code will be slow if you Select the sheets & ranges before clearing, and even more so if you select them individually. You are also selecting whole columns, insrtead of the used cells.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Try
And switch off page break view if it is on ( Tools> options > view > pagebreak off ) before you run the macro.Please Login or Register to view this content.
A V Veerkar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks