Quote:
More sophisticated, maybe, but:
1. It lack the code to call it - it can't run on its own; and
|
Mea culpa. If the OP can't work out how to use the macro it is easy to post en example of how to do so.
Quote:
|
2. Your loop with its repeated selections (myRange.Select) is very inefficient - you should be able to do the lot without selecting anything (except for whatever is selected when the calling macro is run). There are plenty of examples of such code on this forum.
|
Agreed. I've learned a heck of a lot by looking at your code examples. Hence
Quote:
' The myrange.Select are included to show the logic when stepping
' Through the code with F8. They should be deleted for general use
|
Which admittedly occurs halfway through the macro so might easily be overlooked.