title: How to tell if my range of cells is visible
body: <p>The following code is used to process a range of cells selected by the user:</p>
  
  <pre><code>ForEach (var cell in sheet.Range[string.Format("A{0}:A{1}", row1, row2)].Cells)
  {
      // if this cell contains a specific value do something with the row
      if((cell.Value ?? "").ToString() == "1")
      {
          // ...
      }
  }
  </code></pre>
  
  <p>The problem is, some of the rows in the range might have been hidden by a filter.</p>
  
  <p>How can I ensure that I am only processing cells which are visible?</p>