value Property

The Value property(default property for a Range object)

Worksheets(“Sheet1”).Range(“A1”).Value = 75

Worksheets(“Sheet1”).Range(“A1”) = 75

 

MsgBox Worksheets(“Sheet1”).Range(“A1”).Value

MsgBox Worksheets(“Sheet1”).Range(“A1:C3”).Value (generates an error)

Worksheets(“Sheet1”).Range(“A1:C3”).Value = 123