I have a dynamic named range which contains data from 10 colums whose data I add to a listbox: I then add this data to the listbox
I then add this data to the listbox:
Variable: Dim rngSourceShops As Range
Code to add values to listbox:
'Determine number of columns
.ColumnCount = 10
'Set column widths
.ColumnWidths = "0;130;0;110;0;70;80;80;80;10"
'Insert the range of data supplied
.List = rngSourceShops.Cells.Value
The last column contains a value of either "Yes" or "No". I need to display the shops with "yes" only. What code do you suggest I use?
Do I need to create a new named range or is there a way to filter the data with VBA?
I am unfortunately damned to use Excel. :-(
Thanks for your help. I really appreciate it.
PS: Should I upload the spreadsheet to my question?