Hello everybody
I have this code that do auto numbering
The problem is that the code is very slow because of loop ..Is there a way to do the same task quickly?
Please Login or Register to view this content.
Hello everybody
I have this code that do auto numbering
The problem is that the code is very slow because of loop ..Is there a way to do the same task quickly?
Please Login or Register to view this content.
I tried this
Any suggestion about that? Is it Ok? or it need any modification? or is there another idea?Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by jindon; 01-03-2015 at 08:42 PM.
You should also add
Application.Screenupdating = False
at the beginning of your code. Turn it back to True at the end. The screen update takes a lot of time.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Thanks a lot Mr. jindon for this short and effective code
Thanks Mr.Pauleyb for the hint
orPlease Login or Register to view this content.
screen updating on or off makes no essential difference to the speed of these codes. slows them down slightly if anythingPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks