ªð¦^¦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 : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD