Only selecting visible cells in a table with hidden rows

I have a table that I filter so their are rows that are hidden. I then select a column (email list) using the code below. I am trying to figure out how to return only the visible cells in the column.

I am just stuck on this. Thanks in advance.

Joe

Please Login or Register  to view this content.

I would do it this way - assuming you have declared your variables elsewhere, you need to add
Dim c As Range - and you could add error checking to make sure that only a single column or row is selected...

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.