Sub Macro()
Dim rng As Range, rngA As Range, i As Byte
For Each rng In ActiveSheet.UsedRange
If rng.MergeCells Then
If rng.Address = Split(rng.MergeArea.Address, ":")(0) Then '1 获取单元格地址,但这个 : 与 (0) 的作用是什么呢?
If rngA Is Nothing Then '2 为什么平判断 rngA是否为空?它只声明为Range,但没有使用过。
Set rngA = rng '3 赋值是为了什么?赋值后的作用是?
Else
Set rngA = Application.Union(rngA, rng) 'Union目前返回两个合并区域,这里的rngA代码列吗?
End If
i = i + 1
End If
End If
Next
MsgBox i & Chr(13) & rngA.Address
End Sub