Thread: Excel2000: UDF's parameter as cell range OR array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
  
Posts: 510
Default Excel2000: UDF's parameter as cell range OR array
Hi

How to create an UDF which can have as parameter either the cell range or an
array, i.e both syntaxes in examples below will work:

=MyFunction(A2,B2,OtherSheet!$A$2:$A$7)
or
=MyFunction(A2,B2,{2;3;4;5;6;7})


Thanks in advance
--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


Reply With QuoteReply With Quote