Filter by keyword

[christchaaya]

Hi everyone.

I need to filter my table by keyword; this is what I did

ActiveSheet.ListObjects("Tabla1").Range.AutoFilter Field:=5, Criteria1:= _
"Special permit"

as you can see I'm filtering for "Special permit" but the problem is that the database I'm working on has the date of each permit in the same cell and it's different every time ( example "Special permit: 27/03/2013").

How can I filter just by "Special permit" ??

[stanleydgromjr]

christchaaya,

Try see BOLD:

Please Login or Register  to view this content.

[christchaaya]

Sorry for my ignorance but how do I bold the code ?

Thank you for your attention

[christchaaya]

Now i got what you meant. Sorry Thank you a lot you've been very helpful.

Regards

[stanleydgromjr]

christchaaya,

Thanks for the feedback.

You are very welcome. Glad I could help.

Come back anytime.