ªð¦^¦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 : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD