Hi Per

I may have been too quick on my 'you legend' praise. I am trying to
run this on the next chunk of data and I get the following error:

Run-time error '1004':
Selection is too large.

which is the same reason why I initially set my original macro up to
do one column at a time.

Is there any way that I can say for each column starting at BS fill
down to the bottom row, then progress to the next column, repeat until
last column is reached?

Thanks in advance.

David