Hi,

Could someone please provide some sample vba code in excel to do the
following:

Loop for n rows:
Check data in cell x
if cell x 0 then copy contents of cell x and cell y to an array

Then have one string variable which has the contents of array. For
example,

1 Test
2 Test Two
0 Nothing
1 Test Four

Each number on the left hand side is in a cell - the text is also in a
cell next to the number.

So String would output:
1 Test
2 Test Two
1 Test Four

Any help will be much appreciated.

Thanks,