One could write a UDF, but it wouldn't be accurate most of the time,
since changing the active cell doesn't cause a recalculation.

A better way to indicate the active cell would be to use an event macro.
Put this in your worksheet code module:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Range("A1").Value = ActiveCell.Address(False, False)
End Sub

Change the range to suit.


In article .com,
thread wrote:

Hi all,

is it posible to have a formula in excel that indicates the current
cell?