Optimizing existing code

[prabhuduraraj09]

Hi Experts,

I have prepared the 2 codes myself. But i know its a step by step kidos code

I would really need experts help....who could shrink my code. i know it should not look as big its looking now........

Code is all about copy data between workbooks, Refreshing workbooks.

I would really appreciate some experts who could just shrink it effectively Please...
i do tried shinking the code myself.....but im not an expert....

if someone could help me in shrinking it please.


Thank you for reading my post.

[RudiS]

I attempted to shorten and neaten the code as much as possible by removing the selection pairs and various navigational processes that the code does not need to have. There were also a few spelling errors that I corrected and the code now compiles without errors. Of course this is a large automated block and code of transferring data between open workbooks, so I could not do much else without understanding the full context of the transfer process and having source files to test on.

[prabhuduraraj09]

Hi RudiS,

First of all thank you so much for your effort and time that you have spent towards my post.

i really appreciate your effort.

Thanks for the help. Hope this would reduce some running time of my macro.

will keep you posted on the outcome....post testing.