Array from an Array using Index VBA functions

[cmore]

Hi,

I'm not entirely familiar with jagged arrays and VBA functions, still learning. Wondering, is there a way to create an array from an array dynamically similar to worksheet functions?

For instance I can do Index(array/range, ,col begin):Index(array/range, ,col end) where I set col begin by using a match function, and basically dynamically set a range left to right, and obviously do the same with rows for up and down.

Can I do something similar with Application or Worksheet function .Index(array, 0, Col1):.Index(array, 0, Col2)? I have tried to no avail. Thoughts please?

[ragulduy]

Something like this?

Please Login or Register  to view this content.