Address of calling cell?

[DesertCyclist]

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.

 

[Bob Phillips]

Application.Caller.Address

--
HTH

Bob

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

 

[Tim Zych]

Application.Caller returns a range object:

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

 

[Chip Pearson]

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]

Thank you all. This did the trick!

Application.Caller.Address

--
HTH

Bob

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