Dear All,

I wish to create a 3 x n multi dimensional array.

I basically want to do the following:

1. Start off in cell "A1"
2. travel down through 100 cells
3. If activecell contains criteria (eg. has a certain value) then
collect this value, and the value of the next 2 corresponding columns
(adjacent cells).
4. Paste these 3 x n cells of data in another area of the sheet.

eg.. out of the 100 cells looped, I may end up with 33 rows of data
that meet the criteria, therefore have a total of 99 elements in the
array.

I have a good understanding of single arrays, but could somebody please
guide me on such a multi-dimensional array? All the searches I have
undertaken so far don't seem to illustrate this type of array
population.

Regards,

andym