ªð¦^¦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´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD