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.

Please Login or Register  to view this content.

[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

Please Login or Register  to view this content.

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