|
楼主 |
发表于 2009-4-16 09:45
|
显示全部楼层
假如;合并区域为range(cells(4,2),cells(5,3)
Debug.Print Cells(4, 2).MergeArea.Count结果为4
'那么这种组合有三种情况
range(cells(4,2),cells(4,5)).MergeCells
range(cells(4,2),cells(5,3)).MergeCells
range(cells(4,2),cells(7,2)).MergeCells
程序如下:- Sub ls1()
- 'Debug.Print Cells(4, 2).MergeArea.Count
- nn = Cells(4, 2).MergeArea.Count
- cc = 2
- rr = 4
- ccc = cc
- rrr = rr
- For jj = cc To cc + nn
- If Range(Cells(rr, cc), Cells(rr, jj)).MergeCells Then
- ccc = ccc + 1
- Else
- Exit For
- End If
- Next jj
- Debug.Print ccc - 1
- For jj = rr To rr + nn
- If Range(Cells(jj, cc), Cells(jj, cc)).MergeCells Then
- rrr = rrr + 1
- Else
- Exit For
- End If
- Next jj
- Debug.Print rrr - 1
- Debug.Print Range(Cells(rr, cc), Cells(rrr - 1, ccc - 1)).MergeCells
- End Sub
复制代码 |
|