Is there a way for a UDF to know the address of the cell that called it? That
cell may not be the active cell!

Thank you.

Application.Caller.Address

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"DesertCyclist" <(E-Mail Removed)> wrote in message
news:FE296CAA-AEEF-49A7-A4BF-(E-Mail Removed)...
> Is there a way for a UDF to know the address of the cell that called it?
> That
> cell may not be the active cell!
>
> Thank you.

Application.Caller returns a range object:

Function Func1() As String
Debug.Print Application.Caller.Address
Func1 = "test"
End Function


--
Tim Zych
SF, CA

"DesertCyclist" <(E-Mail Removed)> wrote in message
news:FE296CAA-AEEF-49A7-A4BF-(E-Mail Removed)...
> Is there a way for a UDF to know the address of the cell that called it?
> That
> cell may not be the active cell!
>
> Thank you.

In a UDF, Application.Caller returns a Range object referencing the cell
from which it was called.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"DesertCyclist" <(E-Mail Removed)> wrote in message
news:FE296CAA-AEEF-49A7-A4BF-(E-Mail Removed)...
> Is there a way for a UDF to know the address of the cell that called it?
> That
> cell may not be the active cell!
>
> Thank you.

Thank you all. This did the trick!

"Bob Phillips" wrote:

> Application.Caller.Address
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "DesertCyclist" <(E-Mail Removed)> wrote in message
> news:FE296CAA-AEEF-49A7-A4BF-(E-Mail Removed)...
> > Is there a way for a UDF to know the address of the cell that called it?
> > That
> > cell may not be the active cell!
> >
> > Thank you.
>
>
>