Suppose I have worksheet data covering A1:A50; B1:B85, C1:C100, D1:D5
and this is loaded into a listbox using the RowSource property, how
could I, -without reference to the worksheet-, return the number of
rows (seperately) in Columns 1,2,3 and 4. In this instance, the
solution will be 50 for Column1, 85 for Column2, 100 for Column3 and 5
for Column4.

Note that using ListBox1.ListCount property inappropriately produces
the Maximum row length of 100.

Thanks.


--
Myles
------------------------------------------------------------------------
Myles's Profile: http://www.excelforum.com/member.php...o&userid=28746
View this thread: http://www.excelforum.com/showthread...hreadid=507530