Question

如何用VBA判断某一地址单元格是否为合并单元格？

EXCEL中如何用VBA判断某一地址单元格是否为合并单元格？如果是，则其为几列几行合并而成？

Answer 1

Sub myMerge()
Set cel = Range("A1")
If cel.MergeCells Then MsgBox cel.Address(0, 0) & "为合并单元格，" & "共有" & cel.MergeArea.Rows.Count & "行" & cel.MergeArea.Columns.Count & "列组成"
End Sub