Furthermore, keep in mind that listbox indexing is zero based, so for example you get the e- mail address ( column 3, index 2) of your first item row ( index 0) via ListBox1. List( 0, 2), whereas the data field array becomes automatically a one based 2- dim array. No matter what I do with this ( two weeks of off- and- on effort here), it errors out every time I try and get the value from a listbox. I' ve got code to drop it in the excel sheets later, no prob. CANNOT get the cursed thing to give me the text values from the second column.
I just need to get the value of the second column in each entry. Describes how to create a macro to delete duplicate items in a list in Excel.