What is the syntax to set a cell’s value

Range("<cell value>").Value = "<your text>"
Cells(<row number>, <column number>) = "<your text>"

(ex) Range("A1").Value = "Hello World"
(ex) Range("B3:B5, D3:D5").Value = "VBA"
(ex) Cells(1, 4) = "Goodbye"
Advertisements