Dynamic Active cell Formula

[Tahitipit]

Hello,

I am using the formula =CELL("address") to get the reference of the active cell.
Hoewer this formula is not dynamic I need to hit the F9 key to refresh.

Any idea how to make it dynamic ?

Thanks

 

[Hui]

I would add a small piece of VBA code to teh worksheet module for the Worksheet where you want to use this technique

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If [A1] Then Application.Calculate
End Sub

Put the Value True into A1

I added the Check of cell A1 so that you can disable it if you need by changing A1 to False