Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Modify multiple cells at once using a range reference (like A1

Sub MyMacro()          ' Insert the text "Hello" in ten cells          Range("A1:A10").Value = "Hello"      End Sub