View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Find out which cell that called my function

Not sure what you mean by set the comment, but as help says, the Caller
property returns information about how it was called. If it is called by a
function, caller refers to the range that the function is in.

--
HTH

Bob Phillips

"Anders" wrote in message
...
OK, I am hopeful now, but I fail when I try to use the Application.Caller
object to set the comment. I don't understand how the Caller object works

and
the Help doesn't make me wiser.

Thanx in advance
Anders

"DM Unseen" wrote:

Application.Caller

DM Unseen