Cells Property (CellRange)

Gets an System.Collections.IEnumerable that can be used to iterate over the cells in this CellRange.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Cells As System.Collections.Generic.IEnumerable(Of CellRange)

public System.Collections.Generic.IEnumerable<CellRange> Cells {get;}

Example

The code below shows how you can use the Cells property to add all integer values in a given cell range.

var total = 0;
foreach (var cell in rng.Cells)
{
  var value = grid[cell.Row, cell.Column];
  if (value is int)
  {
    total += (int)value;
  }
}

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

CellRange Structure
CellRange Members