I have created an array by querying Access and using the GetRows
method. I now need to apply a worksheet function to that array one
column at a time. Any ideas as to how I can do this?
With a single dimension array, it's not a big deal. Looks something
like this:
Application.Worksheetfunction.Stdev(SingleDimArray)
With a multi-dimension array, I was hoping it might be something along
the lines of:
Application.Worksheetfunction.Stdev(MultiDimArray(0,*))
Not so. Thanks for any help.