View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Papou Papou is offline
external usenet poster
 
Posts: 56
Default 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