Hide rows based on Multiple criteria

[berty2000]

Hi guys

Im trying to hide rows that have the numbers 1 or 2 in column A
I can get it to work for one number but cant seem to get it to see the number 2 as well.
This is what i got so far.

 Dim c As Range
    For Each c In Range("A2:A200").Cells
        If c.Value = "1" And "2" Then
            c.EntireRow.Hidden = True
        End If
    Next c

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[berty2000]

Added the code tags

[Marc L]

Hi,

your codeline just not respects the Logic and the coding logic …
But as a loop is not the best way to go, why don't you use an easy filter or advanced filter ?!

[malcmail]

If this is the way you are goin I think the following will work - note the change in the IF statement

Dim c As Range
    For Each c In Range("A2:A200").Cells
        If c.Value = "1" or c.value="2" Then
            c.EntireRow.Hidden = True
        End If
    Next c

I don't think AND would have worked in that situation.