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

2025-04-06 20:29:54
推荐回答(1个)
回答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