Hello All,

I think this should be easy, but I can't seem to figure it out.

How do I get the address (or range) of the cell that is running a function?

For example, if I have a function in cell B5, how do I know that it is running in B5?

Thanks,
pagates

Hello,

If you want to get a ref to the cell where the function is calling from in your function, the ref of the cell will be returned by "Application.caller".
Be careful because all actions can't be done on the cell, for example you can't change the format of cell ie color.

Hope this will help you.

Regards.
Patdil