I am trying to find a way to use a filtered range as the Rowsource for a
listbox
I hoped to use AutoFilter to provide the data but it doesn't seem
appropriate.
Will I have to copy the filtered data to another area on the worksheet ?
.... or is there a better way to achieve the desired result ?


Regards & TIA