As far as I know you have to create one or more UDF's for this purpose like
this:

Function ActCellAddr()
Application.Volatile
ActCell = ActiveCell.Address(False, False)
End Function

or this:
Function ActCellRow()
Application.Volatile
ActCell = ActiveCell.Row
End Function

Regards,
Stefi


€žPaulW€� ezt Ã*rta:

Is there a formula that returns the address / row / column of the active cell?

So i can use this to produce different results based on the active cell.

PaulW