How do i include " in text in a vba filter

[Tucker92]

I am trying to use an auto filter on my information but the criteria is 12"MET and i don't know how to allow for this in my code because of the quote marks.

Is there anyway i can do this or is there a way my filter can search for the 12 and then the MET and return all the results that contain both?

Help me please

Thank you

 

[vcoolio]

Hello Tucker92,

Try setting up the whole criteria as follows:-

12 & """" & "MET"

e.g.:-

Range("A2:A15").AutoFilter 1, 12 & """" & "MET"

Obviously, you'll need to add your range and autofilter field to suit.

I hope that this helps.

Cheerio,
vcoolio.

 

[Tucker92]

Thank you. Its not coming up with the error anymore.

The issue i have now is that 12"MET isn't the whole name in the column but the rest changes.

Can i make it find the results containing this rather than only this?

 

[vcoolio]

Hello Tucker92,

From what you say, I'm assuming that 12"MET is a constant amongst other numbers and letters, such as:-

12"MET
AS12"METMN
DF12"METR45
etc...

If so, then perhaps the following will work for you:-

Range("A2:A15").AutoFilter 1, "*" & 12 & """" & "MET" & "*"

I hope that this helps.

Cheerio,
vcoolio.

 

[RoryA]

Just FYI, you don't really need concatenation there:

"*12""MET*"

should suffice as the criterion.

 

[vcoolio]

Very true Rory. Thanks for the prompt/reminder.

I'm up too late doing this. Time to give it a rest.

Thanks again.

Cheerio,
vcoolio.