Leith.....

This partially works. The number of columns will vary in the spreadsheet that I need to run this script on. It could have 30 columns or 8 columns. Can you make the script variable as the number of columns to work on?

Thanks for your effort.