Value Property

The Value property returns or sets the cell values in the range. Returns a Variant. This is the default property.

Syntax

object.Value

object.Value = Value

 

Parameter	Type	Description
Value	Variant	required, cell value (text, date, or number)

 

Example

This example demonstrates how to select a cell, return its value, and then change its value.

'Select a cell

Set WksRange = Wks.Cells("A3")

 

'Print the cell value 

Debug.Print WksRange.Value

 

'Change the cell value

WksRange.Value = 2

 

Used by: WksRange object