Thank you Excel Fox for the script - which works exactly as I envisaged it would.

I also realise that I was declaring names that were not needed in the original script. I use the original script for copying data from Excel quote Forms onto an excel master quotation log.

Thank you again.