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

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

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

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD