title: Hide rows based on text cell values in either of two different columns
body: <p>I hide all rows with the value "Kitchen" in column 8.</p>
  
  <p>I also need to hide the row if column 12 contains "No". This is an "Or" statement, not an "And" statement.</p>
  
  <p>I have researched the site, but have not been able to find the answer. I would also like to speed up the process. </p>
  
  <pre><code>Sub FOHc()
  
      BeginRow = 6
      EndRow = 400
      ChkCol = 8
  
      For RowCnt = BeginRow To EndRow
          If Cells(RowCnt, ChkCol).Value = "Kitchen" Or Cells(RowCnt, ChkCol).Value = Blank Then
              Cells(RowCnt, ChkCol).EntireRow.Hidden = True
  
          Else
              Cells(RowCnt, ChkCol).EntireRow.Hidden = False
  
          End If
      Next RowCnt
  
  End Sub
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/sZ0VS.jpg" alt="Spreadsheet "></p>