VBA - Current Cell Address* 30/06/2010

To get the current cell address (or current range) to perhaps incorporate into your formula, you could use the following code.

Sub MyAddress()
MsgBox ActiveCell.Address 'absolute cell reference with the pesky $ signs
MsgBox ActiveCell.Address(RowAbsolute:=False, columnAbsolute:=False) 'without the $ signs, you may choose to omit either one Row / Column absolute
End Sub