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

[µo°Ý] ¤£¦P°Ï°ì¦C¦L¿ï¾Ü

[µo°Ý] ¤£¦P°Ï°ì¦C¦L¿ï¾Ü

¥¼©R¦W.png
2019-12-25 10:40


¦U¦ì¤j¤j
¨¯­W¤F
·Q½Ð°Ý¦p¦ó¥Î«ö¶s¨Ó±±¨î¦L¥X°Ï°ì
¦]¬°¤§«á³øªí·|¦³«Ü¦h¹Ï¦b¦P¤@±iªí¸Ì­±
©Ò¥H·Q¥Î«ö¶s¨Ó¿ï¾Ü¦C¦L½d³ò

¦³ª¦¹L¤åÃþ¦ü¥ÎPrintArea ªº¨ç¼Æ
¦ý¥i¯à¬O¤p§Ì¹ïµ{¦¡¨S¦³«Ü¼ô±x
«ç»ò¼g³£¿ù»~
·Q½Ð°Ý¤j¤j¸Ó¦p¦ó¼g©O?
³Â·Ð¤F

ªþ¤WÀɮצp¤U
¬¡­¶Ã¯1.zip (20.97 KB)
¤£·|EXCALLªº²Â³J

Sub ¦C¦L°Ï_Aªí()
Range("A1:D9").Name = "Print_Area"
End Sub

Sub ¦C¦L°Ï_Bªí()
With ActiveSheet.Shapes("¸ê®Æ®w¹Ïªí 1")
     Range(.TopLeftCell, .BottomRightCell).Name = "Print_Area"
End With
End Sub

TOP

¦^´_ 2# ­ã´£³¡ªL

ÁÂÁ¤j¯«~
­è­è´ú¸Õ¤F¤@¤U¥¿¬O§Ú·Q­nªº
·P®¦±z
¤£·|EXCALLªº²Â³J

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD