Thanks to all contributors. All versions are now working for me.

My expertise is in Excel VBA and Word macros are another country. With apologies to vivka, I have little idea of how these macros actually work, so can anyone advise on which is the most efficient?