|
mr.xia 发表于 2016-9-12 15:36
合并单元格的要取消合并, Cells(i , 1).MergeArea.Count 得到行数再Cells(i, 1).Resize(n).UnMerge,然后 ...
取消合并单元格 供参考
其它的没明白是什么意思...- Sub 取消合并单元格()
- Dim arr, a%
- arr = ActiveSheet.UsedRange
- For a = 2 To UBound(arr)
- If arr(a, 1) = "" Then arr(a, 1) = arr(a - 1, 1)
- Next
- Columns("A:A").UnMerge
- With [a1].Resize(UBound(arr))
- .NumberFormatLocal = "@"
- .Value = Application.Index(arr, 0, 1)
- End With
- End Sub
复制代码 |
|