Move to next cell
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
|