Greetings,
1- Open enclosed file.
2- Run Macro1.
3- Wait some time completing running Macro1.
4- Run Macro2.
5- Wait some time completing running Macro2.
6- Look MessageBox to see that what is Macro2 running time. (Note: My Macro2 running time is 06 minutes and 49 seconds)
My question is how can I decrease Macro2 running time ?
Thanks in advance.
Note: I am open all ideas like copy data to NotePad and paste again excel etc.
Last edited by HerryMarkowitz; 08-20-2014 at 07:07 PM.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
By the way, following codes have no effect of the running time;
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by HerryMarkowitz; 08-20-2014 at 07:16 PM.
Possibly something to do with the fact that's nearly 3 million cells and the formula generates circular reference(s) ... at least, cell A1000 is identified.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi TMS,
Lets forget intervening formulas.
Because I can not change formulating system.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks