none
Excel VBA RRS feed

  • Question

  • How would I be able to check all the cell starting from K12-K65000 and R12-R650000 and enter a value of

    "True" or "False" if there are values in both of these cells K and R. Thanks

     

     

     

     

     

    If Range("K12").Value <= 50 And Range("R12").Value <= 50 Then
       Range("Z12").Value = "Passed"
    ElseIf Range("K12").Value <= 40 And Range("R12").Value <= 55 Then
           Range("Z12").Value = "Passed"

    ElseIf Range("K12").Value <= 30 And Range("R12").Value <= 60 Then
           Range("Z12").Value = "Passed"

    ElseIf Range("K12").Value <= 20 And Range("R12").Value <= 65 Then
           Range("Z12").Value = "Passed"

    Else: Range("Z12").Value = "Failed"
       End If

    Thursday, April 5, 2007 5:15 PM

Answers