View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Papou Papou is offline
external usenet poster
 
Posts: 56
Default Move to next cell

Hi Satch
ActiveCell.SpecialCells(xlLastCell).Offset(1,0).Se lect

HTH
Cordially
Pascal

"Satch" a écrit dans le message de
...
Within macro code, I am trying to activate the cell
directly below the last cell in a single column list. I
have used the following command:

ActiveCell.SpecialCells(xlLastCell).Select

...but I then need to activate the next cell down. Can
anyone help.