Hi Guys,
From another thread (http://www.excelforum.com/excel-prog...30#post3213330)
My VBA is self taught and doubtless lacks good structure. One thing that I'm particularly curious about is the methods used between a macro that I wrote to solve the problem on the above thread and another written by another member whose code does essentially the same exercise but in a fraction of the time that mine runs.
My code was.
The better solution and enormously faster solution was posted by stanleydgromjr as follows.Please Login or Register to view this content.
I'm keen to get some help and advice on better coding practice and structure and also to understand why there is such a large difference in the execution time between the macros.Please Login or Register to view this content.
Many thanks for any help and advice.
Chris
Bookmarks