I have a combobox where the rowsource property refers to a range on a worksheet

i.e. Sheet1!A:

However, I am using Autofilter to reduce this list. I would like only the visable rows on
Sheet1 to populate the rowsource property but it currently includes the hidden ones

Any ideas

Max