LinkBack URL
About LinkBacks
I have a Macro I recorded it takes anywhere from 18 to 20 sec to run. how can I speed it up?
Please Login or Register to view this content.
I have a Macro I recorded it takes anywhere from 18 to 20 sec to run. how can I speed it up?
Please Login or Register to view this content.
If you can provide an example file to work with I'm sure we can work something out.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
deleted, didn't work
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
it moves column C over to column A then if NEW column C
is less then 2 digests it add a 0 to the front.
My code works just slow i have attached an example
The reason it is so slow is that you are selecting three entire columns (i.e. 3,145,728 cells). Set rng to only the cells you need to look at, and it should improve speed massively:Please Login or Register to view this content.
How about 0.08 sec.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks