- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 1# mmggmm - Public Sub ³øªíp1()
- ActiveSheet.ResetAllPageBreaks
- For Each Rng In Intersect(Range("A:A"), ActiveSheet.UsedRange)
- If WorksheetFunction.IsText(Rng.Value) Then
- If Left(Rng.Value, 2) = "¤é´Á" Then
- ' If Rng.Offset(-1, 7) = 0 Then Exit For '³o¥y¬O§@¤°»ò¥Îªº,§â¥¦µù¸Ñ±¼
- ActiveSheet.HPageBreaks.Add before:=Rng.Offset(1, 0)
- ActiveSheet.PageSetup.PrintArea = "A1:F" & Rng.Row
- ActiveWindow.View = xlPageBreakPreview
-
- End If
- End If
- Next
- End Sub
½Æ»s¥N½X |
|