Skip Function if Find Fails

[Shermer321]

How can I get the below function to skip if the word "price" is NOT found?

Please Login or Register  to view this content.

[Shermer321]

Just forced an error resume next. Not pretty but works.

[6StringJazzer]

What do you mean by "skip"? What value do you want this function to return if "Price" is not found?

Calling MATCH after you have already done a Find is redundant--you have already found what you're looking for. Try this:

Please Login or Register  to view this content.