It is that simple actually. You just use a two column listbox and make the
width of the second column 0. You put the address of the cell in the second
column.

I am not sure how you overwrite the list when you loop through cells in L if
you are changing G to 2.

--
Regards,
Tom Ogilvy

"Robert Couchman" wrote in message
...
Hi Tom,

i wish it was that simple!!!

the only unique value in the row is the ID, but i do not
want this present in the listbox, then the other problem
is that when i loop through column G i find that it stops
when it gets to a cell with a value, then writes over the
list when it continues!

thank you,

Robert Couchman
)