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

[µo°Ý]½Ð±Ð¼Æ­È¹ïÀ³ªº¦WºÙ¤è¶ôªºÂà¼g

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-10-6 00:25 ½s¿è

F6=SUBSTITUTE(CELL("address",OFFSET($A$6,,ROW(A1))),"$","")
¦V¤U½Æ»s
VBA
  1. Sub nn()
  2. For Each a In [F6:F8]
  3.    a.Value = [B6].Offset(, i).Address(0, 0)
  4.    i = i + 1
  5. Next
  6. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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