Gary, even though I checked the running of the code and verified that the
cell contents does contain a Cxx value after reading each record, it bypasses
the record
and moves on the to the next record with the final outcome being no records
written.

Any suggestions?

Tony

"Gary''s Student" wrote:

If Left(wsMaster.Range("ag" & iRow + 0),1) = "c" Then
--
Gary''s Student - gsnu200853


"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 "*"?