Wow!
Thank you very much gmayor.
As you will no doubt gathered I am a novice at VBA and this attempt was just trying to emulate what I would do manually.

Thank you for the progress indicator code and the tip on how to do this better and, I am always keen to learn new things if it will help me in life.

Thank you also for rewriting the procedure.

I'll give it a go on Tuesday when back in work.