VBA Selection and Filters

Hello,

This is an obscenely basic problem and I'm embarrassed to even be asking but I'm having trouble working through what is selected when a filter is employed on a list; for this example I have a have a simple list of items in cells a1-a6 (filter is on a1):

Filter
cake
snacks
apples
carrots
peas

If I filter this list to just 'cake' and 'peas' then select (click and drag) a box around those two and copy+paste to a different area of the sheet then I get just cake and peas. However if I run a simple macro on that same selection it performs that action on all of the cells in between as well:

Please Login or Register  to view this content.

I just want the macro to perform its actions on the two selected cells (as the copy and paste did). It should be simple and I know it's just something about the way I'm calling the selection but for the life of me I cant get it to work right and my google-foo is failing me (too many hits throwing any useful search off!). Can anyone help?

One way is to assess the row height.

Please Login or Register  to view this content.

Ah that's cunning, so are filtered rows just 0 height rows?

I would say that there is more that one reason why a row could have a zero height but a filter is one of them.

Just confirming your suggestion worked a treat, thank you for the help!

You're welcome. Thanks for confirming, it's appreciated.