Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Red face Unanswered: If statement with formula inside

    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

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067

    Re: If statement with formula inside

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •