Search notes:

Excel Object Model: cell

The Excel object model doesn't have a distinct object for a cell. Rather, a cell is represented by a Range object that happens to be a 1x1 cell range.

A range that represents an arbitrary cell can be instantiated and accessed by giving the cell's address to the Range »constructor«:

'
'   ..\..\..\runVBAFilesInOffice.vbs -excel b3 -c Go
'

public sub Go() ' {

    range("b3").value = "This is the value of b3"

end sub ' }

Github repository about-MS-Office-object-model, path: /Excel/Range/b3.bas

The currently active cell can be found with application.activeCell.

A cell can have a comment whose content is shown in a so-called «ballon».

application.findFormat sets (or returns) the criteria that are used to find cells with a specific formatting.

Content of a cell

A cell is either

empty, or
stores a value (that has an associated data type), or
contains a formula.

In addition

a cell can be annotated with comment and(?)/or(?) note.
With conditional formatting, the visual appearance of the content changes according to (displayed) value of the cell.
Data validation allows to define rules for values that are permitted to be entered into a cell

Misc

Setting worksheet's .scrollArea allows to restrict selectable cells on the worksheet to the defined area.

Data validation allows to define restrictions (allowed data types and ranges or lists of values) in cells.

Excel Object Model: cell

Content of a cell

Misc

See also