hi, i have a list box on a userform that displays dta from a part of my
spreadsheet. the list will have a different number of rows at different
times but always the same amount of columns. I have worked out that
there will never be more then 200 rows to display so i am currently
using

private sub userform activate
listbox1.columncount = 20
listbox1.list = range("a1:u200".value
end sub

this ensure i get all the dat into the listbox. can i make it smarter
so the list box only displays rows with data in rather then all 200.
Although this method seems to work sometime whne i run the program i am
unable to select certain rows within the listbox. i.e i may have 20
rows in the listbox and i can only highlight 17 of them.

regards

john