A constant assigned to the cell via the CellRange.Value property determines the cell's value. In this case, the cell's value is neither calculated nor changed.
A value resulting from a formula assigned to a cell via the CellRange.Formula property determines the cell's value. In this case, the cell's value is calculated dynamically.
A cell's value can be empty, numeric, text, Boolean or error, and can have various display formats. For example, a numeric value can be displayed as a decimal number, a percentage or currency, a date or time, etc.
Use the properties of the CellValue object the CellRange.Value property returns to retrieve information about the cell's value type, and get the cell's value as an object of the corresponding type.
To get the string specifying the formatted value as it is displayed in a cell, use the Cell.DisplayText property.
The table below lists the available cell value types and provides examples of how to input, format, display and obtain these values.
The cell's CellRange.Formula property is assigned to an error code (for example, "=#DIV/0!", "=#N/A", etc.) or an expression that cannot be calculated correctly (for example, an expression containing an invalid function name, value, division by zero, etc.)
Refer to the Error Types document for more information.