Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Work your way through the entire object hierarchy to set one property

Sub cellValueReference()     Workbooks("Book2").Sheets("Sheet2").Cells(4, "A").Value = "VBA is fun!" End Sub