ªð¦^¦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

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

¦^´_ 2# luhpro


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

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD