View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PatrickS PatrickS is offline
external usenet poster
 
Posts: 26
Default 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?