|
发表于 2013-11-10 09:25
|
显示全部楼层
本楼为最佳答案
本帖最后由 zjdh 于 2013-11-10 09:27 编辑
用不着这么复杂吧- Sub TEST()
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- k = Selection.Column
- R = Selection(1).Row
- N = Selection.Count - 1
- S = R
- For i = R To N + R
- If Cells(i, k) <> Cells(i + 1, k) Then
- Range(Cells(S, k), Cells(i, k)).Merge
- S = i + 1
- End If
- Next
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|