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
|