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

¦b½d³ò¤º´M§ä«ü©w¤º®eªº¦ì¸m

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2012-9-29 22:44 ½s¿è
  1. Dim A As Range
  2. With Range("A1:D5")
  3.     Set A = .Find(what:="TARGET", After:=.Cells(1, 1))
  4. End With
  5. MsgBox A.Address
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD