VBA script to filter column with multiple text strings

**Metrazal** · 10-28-2014, 08:22 AM

I need to filter column S in a spreadsheet. I need the filter to display only cells containing "SSD", "CSSD", or "HLND". The following code returns only cells containing all of the values. (Code treats as: "SSD" AND "CSSD" AND "HLND" I need: "SSD" OR "CSSD" OR "HLND")

Please Login or Register  to view this content.

Any help would be appreciated.

Thanks,

Met

**Naveed Raza** · 10-28-2014, 08:36 AM

Please First check your field number is it really 19 or something else

otherhand replace your filter code with below one

Please Login or Register  to view this content.

**Metrazal** · 10-28-2014, 08:59 AM

Thanks!

That is exactally what I needed. I do have one more issue... I have header information on rows 1-9 that I do not want filtered. (I want these rows displayed) However, rows 7 & 8 are not being displayed. (The filter seems to apply to these rows.) Any ideas?

Thanks again,

Met