View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Keith R[_3_] Keith R[_3_] is offline
external usenet poster
 
Posts: 30
Default 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