View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Writing UDF Help

On Tue, 22 Apr 2008 11:04:18 -0700 (PDT), jlclyde
wrote:

I am trying to write a UDF but I am unsure how to request multiple
arguments of the same type? I am looking for something similar to how
the Sum or the average looks. You can select multiple ranges or cells
and it just gives you another number. Number1, Number2,
Number3...Number30. How is this accomplished?

Thanks,
Jay


Look at the Optional and ParamArray keywords.
--ron