View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] matthijsdezwart@gmail.com is offline
external usenet poster
 
Posts: 6
Default function double output

hi,

I cannot remember how it is called and therefore I cannot seem to find
an example on the internet.

maybe one of you can give me a hand.
I would like to make a function that has an output of two results.

for instance:
I select cells A1 and B1 type =testfunction() and then hit
CRTL_SHIFT_ENTER

then I would like to write output to A1 and other output to b1.
How can I do that?
regards,

Matthijs