Selection using relative cell reference

[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

 

[Per Jessen]

Hi

ActiveCell.Offset(0,1).Select

Regards,

Per

 

[Gord Dibben]

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