Listbox lists

B

Bob

Does anyone know how to ask a listbox to exclude blank
cells from the end of a coloumn list. I've tried using:

i = Worksheets("Sheet1").UsedRange.Rows.Count
UserForm1.ListBox1.RowSource = Worksheets("Sheet1").Range
("A1:A" & i)

Thanks, Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ListBox Remove Certain Text 6
How to set focus on an ActiveX ListBox 7
list box remove item by combobox 4
Dump ListBox Contents to Sheet & Stay on Active Sheet 0
Export listbox items to worksheet 1
Stay on Active Sheet 2
Blank item in listbox, how to remove 3
User Input to Generate ListBox Range 0

Top