If statement with formula inside

$mikly_way$ · #1 (**permalink**) 03-23-04, 15:41

I want to use the If statement with a formula to be validated:

Is there a way for me to write the following but in a way that it would actually work?

For i = 1 to 1
If Left ("ActiveCell", 7) = "604-618" Then
EntireRow.Delete

Where "604-618" is a string value

Thank you

DavidCoutts · #2 (**permalink**) 03-24-04, 08:19

Hi

I think this is what you want

Code:

    If Left(ActiveCell.Formula, 7) = "604-618" Then
        ActiveCell.EntireRow.Delete
    End If

Hope this Helps

David

Internet Services

Web Development

Digital Marketing

Consumer Tech