I'm trying to weed out some data out of an excel spreadsheet with lik
8000 rows. The problem I'm having is that Peoplesoft enters doubl
quotes for each cell and I'm not sure what the escape character (i
that's the solution) for VBA is. For example, I have the followin
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 cel
and I can't use ""Chase, Mary A"" in the If-expression. How can I solv
this problem?

Thanks!

Panuvi

--
panuvi
-----------------------------------------------------------------------
panuvin's Profile: http://www.excelforum.com/member.php...fo&userid=2381
View this thread: http://www.excelforum.com/showthread.php?threadid=40132