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?
|