I am doing an if then statement. I want to check if a cell has a
certain contents, but the text in the cell is on 2 seperate lines and
so the IF statement returns fales and does not clear the cell.

I export a file to excel and then run the macro to update it. I don't
want the contents of the cells to be cleared unless it is this text
that is on 2 lines. The slash in the code is where a paragraph should
be.

This is what I have

If ActiveCell.FormulaR1C1 = "Account Title/Account Name" Then
ActiveCell.FormulaR1C1 = ""
Range("F" & MyRow & ":F" & MyRow).Select
ActiveCell.FormulaR1C1 = ""
Else
End If

Thanks for the help!

Dave

Use

"Account Title" & Chr(10) & "Account Name"

--

HTH

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


"dm16s" wrote in message
oups.com...
I am doing an if then statement. I want to check if a cell has a
certain contents, but the text in the cell is on 2 seperate lines and
so the IF statement returns fales and does not clear the cell.

I export a file to excel and then run the macro to update it. I don't
want the contents of the cells to be cleared unless it is this text
that is on 2 lines. The slash in the code is where a paragraph should
be.

This is what I have

If ActiveCell.FormulaR1C1 = "Account Title/Account Name" Then
ActiveCell.FormulaR1C1 = ""
Range("F" & MyRow & ":F" & MyRow).Select
ActiveCell.FormulaR1C1 = ""
Else
End If

Thanks for the help!

Dave