Question

如何判断一个合并单元格是由哪几个单元格合并的

Answer 1

Sub dafd()
ss = Range("a1").MergeArea.Address(0, 0)
If Range("a1").MergeArea.Cells.Count > 1 Then
If Range("a1").MergeArea.Cells.Rows.Count = 1 Then
MsgBox "行合并"
ElseIf Range("a1").MergeArea.Columns.Count = 1 Then
MsgBox "列合并"
Else
MsgBox "多行多列合并"
End If
Else
MsgBox "非合并单元格"
End If
End Sub

Answer 2

只能通过周围的其他单元格来判断，自身是无法判断的

Answer 3

vba merge range

Answer 4

。。汗 一眼不就看出来了吗