Hi
You can also fill your listboxes with code and loop through the visible cells in the range
For Each cell In Range("A1:A100").SpecialCells(xlCellTypeVisible)
'your code
Next
--
Regards Ron de Bruin
http://www.rondebruin.nl
"SA3214 @Eclipse.co.uk" <sa3214<No Spam wrote in message ...
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