Didn't even spot that <g concentrating on the quotes.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike Fogleman" wrote in message
...
Rows( i ).Delete

"D" would be a column

Mike F

"Bob Phillips" wrote in message
...
If Cells(i, "D") = """Chase Mary""" Then

--

HTH

RP
(remove nothere from the email address if mailing direct)


"panuvin" wrote
in
message ...

I'm trying to weed out some data out of an excel spreadsheet with like
8000 rows. The problem I'm having is that Peoplesoft enters double
quotes for each cell and I'm not sure what the escape character (if
that's the solution) for VBA is. For example, I have the following
if-then


Code:
--------------------

Sub deleteMary()
Dim i As Integer

For i = 2 To 3886
If Cells(i, "D") = "Chase, Mary A" Then
Rows("D").Delete
End If
Next

End Sub

--------------------


The problem is that this particular name already has quotes in the cell
and I can't use ""Chase, Mary A"" in the If-expression. How can I
solve
this problem?

Thanks!

Panuvin


--
panuvin

------------------------------------------------------------------------
panuvin's Profile:
http://www.excelforum.com/member.php...o&userid=23818
View this thread:
http://www.excelforum.com/showthread...hreadid=401320