ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°ÝÃö©ó¹wÄý¦C¦L«á,¦p¦óÅý§Ú¿ï¾Ü¨ì©³­n¤£­n¦C¦L©O?

[µo°Ý] ½Ð°ÝÃö©ó¹wÄý¦C¦L«á,¦p¦óÅý§Ú¿ï¾Ü¨ì©³­n¤£­n¦C¦L©O?

Sub ¦C¦L_¦¬´Ú³æ()

' ¦C¦L_¦¬´Ú³æ ¥¨¶°

    Sheets("¦¬´Ú³æ").Select
    Range("A1:AK61").Select
    ActiveSheet.PrintPreview '¹wÄý¦C¦L
    Selection.PrintOut Copies:=1, Collate:=True '¦C¦L¿ï¨ú½d³ò
    Sheets("¥XÀ\³æ").Select
End Sub

¦^´_ 2# luhpro


    ÁÂÁ±оÇ~¸£µ¬Âण¹L¨Ó

TOP

Sub ¦C¦L_¦¬´Ú³æ()

' ¦C¦L_¦¬´Ú³æ ¥¨¶°

    Sheets("¦¬´Ú³æ").Select
    Range("A1:AK61").Select
...
starry1314 µoªí©ó 2015-6-6 17:53

³o¤@¦æ®³±¼ :
Selection.PrintOut Copies:=1, Collate:=True '¦C¦L¿ï¨ú½d³ò

¨Ï¥ÎªÌ­Y­n¦L¥Xª½±µÂI¹wÄýµe­±¤W¤èªº ¦Lªí¾÷¹Ï¥Ü(©Î "¦C¦L" «ö¶s),

­Y¤£­n¦C¦L«hÂI ¹wÄýµøµ¡ ªº X «ö¶sÃö³¬µøµ¡ (©Î¬O¤W¤èªº  "Ãö³¬" «ö¶s) §Y¥i.

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD