Move to next cell

  • Thread starter Thread starter Satch
  • Start date Start date
S

Satch

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.
 
Hi Satch
ActiveCell.SpecialCells(xlLastCell).Offset(1,0).Select

HTH
Cordially
Pascal
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
"Move to bottom of range" 18
macro recording 3
How do I pass a variable cell reference to a Range Object? 2
GoToEnd Macro 4
code help 0
How to return column number 4
XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select 2

Back
Top