Mike, when I use your code, I get a Run-time error '13' - Type mismatch error.

"Mike H" wrote:

I just noticed you may want it to ignore case

If InStr(1, Sheets(wsMaster).Range("ag" & irow + 0), "c", 1) = 1 Then

Mike

"Mike H" wrote:

Try instr

If InStr(Sheets(wsMaster).Range("ag" & irow + 0), "c") = 1 Then

Mike

"Tony" wrote:

I have the following could that checks a column in a master file to select
records that have the following c* (i.e. c01, c02, etc..). However due to
some error in the way I am writing the code, I cannot get it to produce
records.


If wsMaster.Range("ag" & iRow + 0) = "c* " Then

How do I code it the slect any records that start with "C" and then use the
wildcard character "*"?