Answered by : vastemonde

Range("A2").Value = 1
Cells(2,1).Value = 1
Range("A2:A5").Value = 1 ' all cells in the range

Source : | Last Update : Thu, 25 Mar 21

Answered by : zwazel

Cells(row, col).Value

Source : https://www.automateexcel.com/vba/cell-value-get-set/ | Last Update : Thu, 29 Jul 21