I had one more question about this code. I saved this macro in a master file that opens at startup that is hidden so that I can use this macro in all my workbooks.
When I run the macro in another workbook it work, but it seems to continue to loop. It locks up excel until I hit the ESC key.
But when I run this code in the workbook that it is saved in, it does not lock up excel and works just fine.

Do you know why this could be?

Thank you