none
How to do "If cell contains" in VBA

    Question

  • Hi,

      I'm looking for the code to do an if statement when a cell contains "CHECKED OUT"
      I have been using the code below but of course it reads the whole contents of the cell and the cell with say CHECKED OUT by ...

    If ActiveSheet.Range("C6").Value = "CHECKED OUT"

    Thanks,

    Richard
    Monday, September 07, 2009 1:37 PM

Answers

All replies