Snasui Excel Forum

You are awesome Santipong, thank you!
Kristina

Wow - thank you! I have no idea what this new code means (I was just using yours from YouTube)! I'll have to do some research.
How could I change this line to search more than 1 column, or the whole table?

For Each r In .Range("c3", .Range("c" & .Rows.Count).End(xlUp))

Thank you VERY much ...

Hello, I've attached the file. The search box is in B1.

Problem 1: It doesn't seem to launch a search every time though. I have to click in the box and hit the Delete button for all of the data rows to be returned to normal (possibly I've done something wrong).

Problem 2: And for some reason it ...

Hello, in your example of MyAdvancedSearch, is there a way to constrain the search to look only at specific columns, rather than the whole range?

Thank you, Kristina