how to? set my range= my UDF argument (range vs. value in range) [advanced?]
Worked like a charm- thanks Tom!
:)
Tom Ogilvy wrote in article
...
I think you are misinterpreting what is being returned in your choose
function. It returns a range for me (you would get an error on the set
statement if it didn't).
Anyway, with this adjustment to your second function, it worked for me
(I
use the vba offset rather than worksheet).
<snip
--
Regards,
Tom Ogilvy
|