å¦æåªæ³æå°sheet5~sheet10,sheet1~sheet4ä¸éæå°ï¼åå¦ä½æ§è¡ï¼
追çå¦æåºå®æ¯5-10é£ä¹å°±æ¹æ
Sub aa()
For n=5 to 10
sheets(n).PrintOut From:=1, To:=1, Copies:=1
Next n
End Sub
sheet1~sheet10åªæ¯ä¸ªä¾åï¼é½æ¯æå¦å¤çä¸åå½åï¼ä¸åç»è¿ä¸ªexcelè¿ä¼ä¸æçæ°å¢ä¸åå½åçSheetï¼åå·²æå°è¿çä¸åéæ©æå°ï¼åªå¯¹æ°å¢çææå°ã
追çSub aa()
Dim sht As Worksheet
For Each sht In ActiveWindow.SelectedSheets
sht.PrintOut From:=1, To:=1, Copies:=1
Next
End Sub
è¿æ ·å§ï¼åªéè¦ä½ éä¸éè¦æå°ç表åï¼å³æä½shiftç¹å»èµ·å§åæç»ç表ï¼ç¶åè¿è¡è¿ä¸ªå®ï¼é£ä¹å°±ä¼æææ被éä¸è¡¨ç第ä¸é¡µæå°åºæ¥ã
如果只想打印sheet5~sheet10,sheet1~sheet4不需打印,又如何执行!
追答那就先按住CTRL键,然后在分别取选择你指定的sheet表中要打印的内容,打印时选择“指定区域”,你可以试试