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

[µo°Ý] ªíÀY©M­¶©³ªº¤å¦r³¡¤ÀªºÄݩʦ³¥i¯à³Q§ó§ï¶Ü?

[µo°Ý] ªíÀY©M­¶©³ªº¤å¦r³¡¤ÀªºÄݩʦ³¥i¯à³Q§ó§ï¶Ü?

µ{¦¡¤ù¬q¦p¤U:

With ActiveSheet.PageSetup
        .LeftHeader = "­Ü®w¥X³f°O¿ýªí"
        .RightHeader = "µ{¦¡²Ä0001¸¹"
        .RightFooter = "²Ä &P ­¶¡A¦@ &N ­¶"
End With


¦p¤W,¦b³øªí¦C¦L¤¤, "­Ü®w¥X³f°O¿ýªí" ³o¨Ç¦r¦êªºÄÝ©Ê¥i¯à³Q§ïÅܶÜ?
¦p§ï¦¨ ¶ÂÅé ¼Ð·¢Åé  §ï¦¨ ²Ä 18 ¸¹ ¦rµ¥ ...
V98

¦^´_ 1# linshin1999
¬O²ÊÅ餣¬O¶ÂÅé.
¥Î¿ý»s·s¥¨¶°¥i±o.
With ActiveSheet.PageSetup
        .LeftHeader = "&""¼Ð·¢Åé,²ÊÅé""&18­Ü®w¥X³f°O¿ýªí"
        .RightHeader = "&""¼Ð·¢Åé,²ÊÅé""&18µ{¦¡²Ä0001¸¹"
        .RightFooter = "&""¼Ð·¢Åé,²ÊÅé""&18²Ä P ­¶¡A¦@ &N ­¶"
End With

TOP

¦^´_ 2# GBKEE


    GBKEEª©¥D ÁÂÁ§A,ªoº£´N¬O­n¨ê¤l,§ä¤£¨ì¨ê¤lªº®É­ÔÁÙ¯u³Â·Ð,¦³§A­Ì§Ú­Ì¥i¥H¸`¬Ù«Ü¦h§ä¨ê¤lªº®É¶¡,ÁÂÁ¤F!!
V98

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD