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

[µo°Ý] ½Ð°Ý¦p¦ó«ü¥O¥i¥H¹D¹Ï§Î©Ò¦bÀx¦s®æ¦ì¸m

[µo°Ý] ½Ð°Ý¦p¦ó«ü¥O¥i¥H¹D¹Ï§Î©Ò¦bÀx¦s®æ¦ì¸m

¦]¬°¤£ª¾¹Dshape »P Cells¶¡ªºÃö«Y¦p¦ó«Ø¥ß¡H

¦^´_ 1# mfsong
  1. Option Explicit
  2. Sub Ex()
  3.     MsgBox Sheets("Sheet1").Shapes(1).TopLeftCell.Address
  4. 'TopLeftCell  ¶Ç¦^ Range ª«¥ó¡A¸Óª«¥ó¥Nªí«ü©wª«¥ó¥ª¤W¨¤¤U­±ªºÀx¦s®æ
  5. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE


    ÁÂÁª©¤j¡I

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD