Only copy visible data to ListBox

Hi guys,

i hope you can help me.

I am trying to copy a range of filtered data to a ListBox, but am struggling with the parameters.

1. How can I edit this sub to only copy the visible data of my Range ("RecordData");
2. Not copy the first row - headers;
3. Not copy empty rows in this range?

Please Login or Register  to view this content.

Thank you for all your help!

Please Login or Register  to view this content.

If you're setting the filter through code, you should check that the range DOES exist.

Please Login or Register  to view this content.