none
If not statement RRS feed

  • Question

  • I need to know if

     

    wksws.Range("O" & artquan) > 0

     

    or

    wksws.Range("O" & artquan) = "E"

    but what i did is not working

    “If Not wksws.Range("O" & artquan) > 0 Or wksws.Range("O" & artquan) = "E" Then”

    I know cell “O15” has an “E” value so the if stamen should go to end if but does not  

     

    The variable “artquan” is 15 I have it in my watch window end I can see it


    Vforum

    Sunday, November 3, 2019 7:06 PM

Answers

  • Does this do what you want?

    If Not (wksws.Range("O" & artquan) > 0 Or wksws.Range("O" & artquan) = "E") Then


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Kosta si Sunday, November 3, 2019 9:31 PM
    Sunday, November 3, 2019 9:19 PM

All replies

  • Does this do what you want?

    If Not (wksws.Range("O" & artquan) > 0 Or wksws.Range("O" & artquan) = "E") Then


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Kosta si Sunday, November 3, 2019 9:31 PM
    Sunday, November 3, 2019 9:19 PM
  • thank you

    Vforum

    Sunday, November 3, 2019 9:31 PM