Combining Multiple Range Values into a Single Array

Hey,

Say I have several ranges (A1:A3,A5:A10,A13:A20) with different values in each cell. The values will change on a weekly basis. I want to store these range values into a single array, so I can perform different tasks on the array. How would I go about doing this?

Thanks.

Hello fervorking,

This UDF will take a range and convert it into a 1-D zero based array.

Please Login or Register  to view this content.

Example of Using the Macro
This will convert the range shown into a single dimension array.

Please Login or Register  to view this content.