Logic statement help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nkf53
    New Member
    • Jun 2010
    • 17

    Logic statement help

    Sorry for the bother again, I've been continuing improving what I made, and was just now trying to make a if then statement work by putting it before this. Such as If Ash.columns("e" )> ash.columns("F) " Then (the following will occur. I'm not even sure if this is possible. But Thanks for even taking the time to read this.



    Code:
          
        For Each cell In Ash.Columns("b").Cells.SpecialCells(xlCellTypeConstants)
            If cell.Value Like "?*@?*.?*" And LCase(cell.Offset(0, 2).Value) = "yes" Then
            'Use this to set range of Cells, as in what columns to put in
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    I'm not really sure what you are asking but you can nest any series of statements.

    Code:
    If <Statement> Then
        For i=1 to 100
            If <Statement> Then
                Do this
            Else
                Do this
            End If
        Next i
    Else
        Anything you want
    End If

    Comment

    Working...