Value Property

The Value property returns the value of the specified cell. If the cell is empty, Value returns an empty string. This can be tested in either of the following ways:

If the Range object contains more than one cell, the Value property returns a two-dimensional array. For instance, referring to Figure 19-16, the code:

Dim v As Variant v = Range("A1:A3").Value Debug.Print IsArray(v)

will print:



0 0

Post a comment