title: Multiple ranges in one VBA For loop?
body: <p>I am a beginner at VBA and am trying to highlight only empty cells in columns N and AA only.  Can there be multiple ranges in one For loop to make this work instead of the following code?</p>
  
  <pre><code>Private Sub CommandButton22_Click()
      'HIGHLIGHT
      Dim cell As Range
  
      For Each cell In Range("N")
          If cell.Value = vbNullString Then
              cell.Interior.ColorIndex = 6
          End If
      Next cell
  
      For Each cell In Range("AA")
          If cell.Value = vbNullString Then
              cell.Interior.ColorIndex = 6
          End If
  
      Next cell
  End Sub
  </code></pre>