Cell address of function call
 

I have a function in my spreadsheet and I would like to know within that code
what cell the function is being called from, but I have no idea how to
achieve this. Perhaps somebody here can point me in the right direction?

Cell address of function call
 

I've found it. Application.Caller.Address seems to do the job nicely.

"PatrickS" wrote:

I have a function in my spreadsheet and I would like to know within that code
what cell the function is being called from, but I have no idea how to
achieve this. Perhaps somebody here can point me in the right direction?