View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ralph K Ralph K is offline
external usenet poster
 
Posts: 1
Default Passing arrays to VBA module

My experience with user defined functions has been limited to simple
procedures using individual data items as arguments. Now, I need to grab
a range of values from the SS, pass them to a function as one or more
arrays, read the arguments into local arrays withing the VBA procedure,
perform my process, and return the function value.

I need a simple illustration of this process but have had no luck with
the Excel/VBA help. Where should I look?