WorksheetBase.Cells Property
Gets a Range object that represents all the cells on the worksheet (not just the cells that are currently in use).
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public ReadOnly Property Cells As Range
public Range Cells { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Range
A Range object that represents all the cells on the worksheet (not just the cells that are currently in use).
Remarks
The following code example uses the Cells property to set the name, size, and boldness of the font in every cell on the worksheet.
This example is for a document-level customization.
Private Sub SetCellFonts()
With Me.Cells.Font
.Name = "Verdana"
.Size = 14
.Bold = True
End With
Me.Range("A1", "A5").Value2 = 123
End Sub
private void SetCellFonts()
{
this.Cells.Font.Name = "Verdana";
this.Cells.Font.Size = 14;
this.Cells.Font.Bold = true;
this.Range["A1", "A5"].Value2 = 123;
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.