Hi,

I have this code which is called from a cell on a worksheet:
Public Function CountT(iRow As Integer)
    Debug.Print Application.Caller
End Function
I want to get the address and worksheet name of the cell which called the function. This could be in multiple cells across many different worksheets.

when I set a breakpoint and add Application.Caller to the watch window, I get 'Error 2023'

Does anyone have any ideas how I can get this to work? Do I need any references set?

Thanks