If then using a wildcard to search for text

[fly2079]

I am needing to loop through a series of cells and search for a criteria. The criteria could be something like 'C172' and I want to add that whole row to a range if the cell contains even just the 'C' part or just the '1' part etc. Is there a way to do a wildcard search in vba like
If Range("A:1").Value = "C*" so that I can do something if the value of the cell starts with 'C'?

[ This Message was edited by: fly2079 on 2002-02-19 07:56 ]

[Barrie Davidson]

On 2002-02-19 07:55, fly2079 wrote:
I am needing to loop through a series of cells and search for a criteria. The criteria could be something like 'C172' and I want to add that whole row to a range if the cell contains even just the 'C' part or just the '1' part etc. Is there a way to do a wildcard search in vba like
If Range("A:1").Value = "C*" so that I can do something if the value of the cell starts with 'C'?

[ This Message was edited by: fly2079 on 2002-02-19 07:56 ]

You can try this:

If UCase(Left(Range("A1").Value, 1)) = "C" Then 'rest of your code

Note, this will work regardless of the case of the letter (i.e., "C" or "c") but you will get an error if A1 is numeric.

[fly2079]

Ok, now what do I do if I want to search for the numeral 1 or 7 or 172. What this I'm using this for is the user inputs values into a box and I want to have the option of searching for 'contains' in other words search for through and find if part of the value is in the cell. Is this a UDF?