rsrasc, Thanks for the kind words. There are optimisations that could be made that I didn't bother with, since your files are pretty small. One that I should have made, however, is to stop screen updating while the macro is running. The macro jumps around a lot, which takes screen refresh time. At the beginning of the macro, you could add:
Code:
Application.ScreenUpdating = False
and at the end:
Code:
Application.ScreenUpdating = True