G Guest Oct 26, 2007 #1 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.
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.
B Bob Phillips Oct 26, 2007 #2 Application.Caller.Address -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
Application.Caller.Address -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
T Tim Zych Oct 26, 2007 #3 Application.Caller returns a range object: Function Func1() As String Debug.Print Application.Caller.Address Func1 = "test" End Function
Application.Caller returns a range object: Function Func1() As String Debug.Print Application.Caller.Address Func1 = "test" End Function
C Chip Pearson Oct 26, 2007 #4 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)
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)
G Guest Oct 26, 2007 #5 Thank you all. This did the trick! Bob Phillips said: Application.Caller.Address -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Click to expand...
Thank you all. This did the trick! Bob Phillips said: Application.Caller.Address -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Click to expand...
