Cell Address
 

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

Thanks in advance

Cell Address
 

Try this

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Thomas" wrote in message ...
How would I define the cell address of the cell above my
activecell?

Thanks in advance

Cell Address
 

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

End Sub


"Thomas" wrote in message
...
How would I define the cell address of the cell above my
activecell?

Thanks in advance

Cell Address
 

One way: ActiveCell(0, 1).Address

Alan Beban

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

Thanks in advance