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.
***
|