Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to use Application.Caller to determine if VBA or a cell has called
my UDF. However, when called from the worksheet in a particular UDF, Application.Caller = -1711800260 and its TypeName is Double. However, when I send Application.Caller to an IsRange function, it is passed as a valid range. When I type in the Immediate window Application.Caller.Columns.Count, it returns the 'Object Required' error. I don't understand it. Has anyone else had this problem/ Thanks, Matthew Pfluger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
application.caller | Excel Programming | |||
application caller | Excel Programming | |||
Row = Application.Caller.Row | Excel Worksheet Functions | |||
Application.Caller | Excel Programming | |||
Application.caller | Excel Programming |