Thanks for the reply.

Unfortunately, I'm VBA illiterate. When I paste this in to the VBA window and save it then try and run the macro, nothing seems to happen?

Is there anything I'm not doing that I'm supposed to?