extracting a subset of an array with VBA.
Use a variant to return arrays
----- y wrote: ----
Hi all
I need to extract an array from another. The dest array will contain,e.g., the even elements of the
first one
Which code of VBA could help me
I've thought something thi
Function Subset (source As range) As ? (I don't know, I need an array, not a range
.... my algorithm ..
End Functio
This function will be called in a cell as an argument inside several Excel functions
Could someone tell me how can I return an array? Do I have to take care about some troubles i
particular in building this function
Thanks in advance
Alex
|