How to Search Excel Cells for Multiple Text Comparison

[PosseJohn]

I have several text criteria for a range that I need to hide the corresponding rows if found.

I have tried the following:

Please Login or Register  to view this content.

The code works, but takes a fairly significant amount of time to complete.

Is there a more efficient way of accomplishing this?

[jewelsharma]

have you tried combining all the IF (TEST1) ELSEIF (TEST2) ELSEIF (TEST3) .... code into a single IF (TEST1) OR (TEST2) OR (TEST3) ... style already?

Please Login or Register  to view this content.

BTW, I'm not sure if this will speed up the code or not. I'm hoping it would improve slightly.

[skywriter]

Does your data really go to J15000?

If not, the first thing you should do is narrow the search range down to the actual range with data.

[jindon]

Use AdvancedFilter like

Please Login or Register  to view this content.

Assuming header in J2.