Macro runs fast when I step through it until I go to one of my sheets and it gets to this code... what would cause this to take so long the rest of the macro takes seconds and this piece here takes about 2 minutes to complete... is there an easier way of doing this I need it to clear all borders from the sheet...
Current Code:
Thanks,
Please Login or Register to view this content.
Hi,
Have you set Application.ScreenUpdating = False before you do the changes ?
Your code should be like :
RegardsPlease Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
How were the borders put in?
selects 16,777,216 cells in excel 2003 (65,536 Rows and 256 Columns)Please Login or Register to view this content.
Can you change it to a realistic number.
Is this any faster?
Please Login or Register to view this content.
Last edited by jolivanes; 11-21-2014 at 12:09 AM.
It was referencing some outrageous cell as stated above and causing it to take forever... Thanks Everyone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks