- ©«¤l
- 233
- ¥DÃD
- 53
- ºëµØ
- 0
- ¿n¤À
- 292
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXp
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-1-6
- ³Ì«áµn¿ý
- 2024-3-8
|
¥»©«³Ì«á¥Ñ jackson7015 ©ó 2014-5-30 17:09 ½s¿è
¦^´_ 5# 013160
³oÓ´N»Ýn§Q¥Î¨ìVBA¥h½sĶ¤F
§Ú¥u·|³oºØªº¡A¦pªGn¦b½ÆÂøªº¸Ü¡A´N¥hµ{¦¡°Ï½Ð±Ð«e½ṳ́F- Private Sub Workbook_BeforePrint(Cancel As Boolean)
- Sh = ActiveSheet.Name
- If Sh = "¶µ¥Ø1" Then
- If [E6] = "" Then
- LR = 5
- Else
- LR = Application.CountA([C6:C65535])
- LR = Application.RoundUp(LR, -1) + 5
- End If
- ActiveSheet.PageSetup.PrintArea = "C1:I" & LR
- End If
- End Sub
½Æ»s¥N½X
¬¡¶Ã¯1.rar (57.71 KB)
|
|