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:

    Dim cell As Range
    For Each cell In Selection
        cell.Value = WorksheetFunction.Proper(cell.Value)
    Next
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?