| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Application.Caller valid in Functions but not Subs?
This works fine in all Functions I've written but throws an 'Object
required' in a Sub I'm writing: Dim R as Range Set R = Application.Caller If Application.Caller is invalid in a Sub, then what expression DO you use in a Sub to return the cell the user was on when he launched the Sub? Thanks much. *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| application.caller | Excel Programming | |||
| Row = Application.Caller.Row | Excel Worksheet Functions | |||
| application.caller | Excel Programming | |||
| Application.caller | Excel Programming | |||
| DDE and application.caller help | Excel Programming | |||
Threaded Mode
