Hi NoSparks, as always thank you for your support.

As you suggested I moved the code to a standard module but I'm not sure or let say I don't know if what you mentioned about the ActviveWorkbook and the Active Sheet will allow the macro to run without any problems. I ran the code but didn't go all the way to the end.

Regards!