|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
这题目是犯禁忌:讨论破解问题
还是解不开?
wkbu指定的宏是
Sub WKBU() '跨分页符的合并单元格分割_WKBU
Range("A200").Select
Dim i%, j%, md%, ipage%, k%, kk%, ku%, ilastrow%
Application.ScreenUpdating = False
Application.DisplayAlerts = False
ipage = ActiveSheet.HPageBreaks.Count: md = 1
For k = 1 To ipage
ilastrow = ActiveSheet.HPageBreaks(k).Location.Row - 1 '判断每页最后一行的行数
For j = 1 To 13
For i = md To ilastrow
If Cells(i, j).MergeCells Then kk = Cells(i, j).MergeArea.Rows.Count: ku = Cells(i, j).MergeArea.Columns.Count
If Cells(i, j).MergeCells And (kk + i - 1) > ilastrow Then
Cells(i, j).Select
Cells(i, j).UnMerge
Cells(i, j).Value = ActiveCell.Value
Cells(ilastrow + 1, j) = ActiveCell.Value
Range(Cells(i, j), Cells(ilastrow, j + ku - 1)).Merge
Range(Cells(ilastrow + 1, j), Cells(i + kk - 1, j + ku - 1)).Merge
End If
If Cells(i, j).MergeCells Then i = kk + i - 1
Next
Next
md = ilastrow + 1
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
[ 本帖最后由 FXSHENG 于 2010-3-19 21:22 编辑 ] |
|