使用对象变量和With语句简化对象的引用

本文为《别怕，Excel VBA其实很简单（第3版）》随书问题参考答案

Sub 设置单元格()
Dim rng As Range
Set rng = ThisWorkbook.Worksheets(1).Range("A1")
With rng
.Clear
.Value = "Excel Home"
.Font.Name = "宋体"
.Font.Size = 16
.Font.Bold = True
.Font.ColorIndex = 3
End With
End Sub