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

Ãö©óVBA¦C¦L°ÝÃD

Ãö©óVBA¦C¦L°ÝÃD

½Ð°Ý¦U¦ì¤j¤j
VBA¦³¿ìªk¿ï¾Ü¦C¦L¤u§@ªí¶Ü
¤u§@ªí¸Ì­±ªºÀx¦s®æµ¥©ó­n¦C¦Lªº¤u§@ªí¦W ´N¦C¦L¸Ó¤u§@ªí
¦C¦pA1Àx¦s®æ µ¥©ó AAA ´N·|¦C¦L¥X AAA ªº¤u§@ªí
    A1Àx¦s®æ µ¥©ó BBB ´N·|¦C¦L¥X BBB ªº¤u§@ªí

¦p¤U¸Ì­±¬õ¦âªºAAA­nÀHµÛÀx¦s®æ§ïÅÜ
With Sheets("AAA").PrintOut '¦C¦L
End With

­n¦p¦ó°µ­×¥¿©O

¦^´_ 2# Hsieh

·PÁÂ Hsieh ¤j¤j
¦]¬°³o­Ó¤èªk¤p§Ì¤£ª¾¹D«ç»ò¨Ï¥Î¥¨¶°¨ú±o
©Ò¥H¤W¨Óµo°Ý
¤p§Ì´ú¸Õ«á ¥i¥¿±`¨Ï¥Î
¸U¤À·PÁÂ

TOP

With Sheets([A1].text).PrintOut '¦C¦L
End With
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD