Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Change the Value property for a range of any size

Sub changeMain()     Worksheets("Sheet1").range("A1:C3").value = 123 End Sub