Selection using relative cell reference

  • Thread starter Thread starter Emma Aumack
  • Start date Start date
E

Emma Aumack

Hi All,

I am in the active cell, say B189, I want to select the cell to the right
(C189) using relative cell reference. Can someone help me?

Thanks
 
ActiveCell.Offset(0, 1).Select

That is offset(row, column)

Note: you don't generally have to select a cell to act upon it.

ActiveCell.Offset(0, 1).Value = "Hello" would place the word Hello in the
cell without selecting the cell.


Gord Dibben MS Excel MVP
 
Back
Top