Cell Address

[Thomas]

How would I define the cell address of the cell above my
activecell?

Thanks in advance

 

[Ron de Bruin]

Try this

MsgBox ActiveCell.Offset(-1, 0).Address

 

[Don Guillett]

Is this what you want?
Sub defineabove()
x = ActiveCell.Offset(-1).Address
MsgBox x

End Sub

 

[Alan Beban]

One way: ActiveCell(0, 1).Address

Alan Beban