Glad to help Satch
Cordially
Pascal

"Satch" a écrit dans le message de
...
Hi Papou,

Thanks for your help. The suggested command actually made
a seemingly random cell on the sheet active, rather than
the next from last in a column. I applied the "Offset"
part to a command that I had tried previously and this has
worked, so thankyou very much for introducing me to that.

The command used was:

Selection.End(x1Down).Offset(1,0).Select


Regards,

Mark Satchwell