代碼:
Sub 巨集1()
'
' 巨集1 巨集
On Error Resume Next
Application.WindowState = wdWindowStateMaximize
Dim s As String
s = ""
Dim j As Integer
j = 0
Dim k As Integer
k = 0
Do
Selection.MoveUp Unit:=wdLine, Count:=1
Selection.HomeKey Unit:=wdRow
Selection.SelectCell
s = Selection.Text
If (Left(s, 2) = "00") And (Len(s) > 10) Then '判斷是標題
Selection.InsertBreak Type:=wdPageBreak
j = j + 1
End If
k = k + 1
Loop Until (j > 590) or (k > 10000) 'j看有幾個表減1, k設比行數多防變成死循環
End Sub
先寫一個巨集跑
只是這樣有591個表佔了大約400頁要切
每切一個表就要幾10秒要跑滿久的
(咦, 好像是剛開始幾次切的時間比較久, 後面大概3秒鐘切1個表, 還滿快的)