Hello NoSparks,

Perfect.
Thank you very much for persisting with me, I really appreciate all your help.

What I was trying to explain and show, was that there could be other blank cells in column A and that using .End(xldown) would not work (as you put it "blank cells from the top"). Various blank cells in column A could still be waiting on more information before being filled in.

The second last cell in column A is where I am up to when working my way down and filling in the information across the row.

Once again, thanks to you and Logit for all your help.

Regards, Dave T