Hi,
Macro code is calculating value to 347884 cells. Macro doesn't have any trouble, it is running but the process takes too long time.
Can we make an arrangement to reduce the time?
Code:
Thank you helping.
Please Login or Register to view this content.
Regards.
Try this and please verify the results before using it in production!
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
Thank you very much.
It took 10 seconds.
Does the data look correct?
Yes, data look correct. Only l change this code (Case "DO", "ĘD", "TO", "ĘT") to (Case "DO", "İD", "TO", "İT")
Hi romperstomper,
Code is working perfect but l don't use this code in my another code.
Example:
Cells(2, B) is changing with ColumnData(1, B) as in code.
but When l change Cells(1, B) to ColumnData(0, B). Macro is not working.
Another Old slow code:
New Code but it is not working.Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you for your helping.
Regards
You have only loaded rows 2 to 5 into ColumnData so you need to change this line:
to this:Please Login or Register to view this content.
and then do not subtract one from the indices when using ColumnData, so Cells(1, B) is replaced with ColumnData(1, B)Please Login or Register to view this content.
Re: Macro Processing Time Acceleration
Edit : misreading of source range, my tip does not apply in this case …
Last edited by Marc L; 09-23-2014 at 04:38 AM.
Thank you so much.
Nice Day.
Last edited by ofd2008; 10-02-2014 at 04:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks