Add to a two dimensional dynamic array based on a condition - redim preserve

hi

i have a column with some cells containing text and others numbers. I would like to go down the sheet
and when i get to a cell with a number. add it to the array and right next to it, the cell address.

i don't want to have any empty array elements, so i cant just add the whole column to a variant.
The array should be 'redim preserved' only when i encounter a cell with a number in it.

i basically want to end up with an array that when written to a worksheet is a two column range
with x number of rows.

how would i go about this please?

Try this:-
NB:- Basic Data in column "A", Results vin columns"D/E".

Please Login or Register  to view this content.

Regards Mick

hi Mick! Thanks very much. this worked and i modified it a little too.
im relatively new to VBA and cant get my head round arrays, got myself in knots with "Redim preserve" etc

Appreciate the help mate!

cheers

You're welcome