I am baffled by the LISTCOUNT returned value of 1048537 in the following code


targets_list.RowSource = "PROJECT!" & Sheets("PROJECT").Range("A40", Sheets("PROJECT").Range("N65535").End(xlDown)).Address
target_count = targets_list.ListCount

The targets_list LISTBOX populates nicely. I only have one row that is read from a worksheet that is 14 columns wide. By my reckoning LISTCOUNT should return a value of 1 since there is only 1 row in the LISTBOX (targets_list)

What goes on ? Anybody encounter this problem ?

Help please !