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