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?
PatrickS - 25 Sep 2007 10:48 GMT
I've found it. Application.Caller.Address seems to do the job nicely.
> 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?