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

[µo°Ý] ¼Æ²Õ¾ã¦C¾ãÄævba¦p¦ó¼g

[µo°Ý] ¼Æ²Õ¾ã¦C¾ãÄævba¦p¦ó¼g

dim A(1 to 100,1 to 100)
­n¼g¥X²Ä5¦C,excel¥i¥H¥Î index(A,5,0)ªí¥Ü
vba¥i¥H¦p¦ó¼g©O?(·íµM¤£¥Îloop),¨D±Ð
lmh

application.index

TOP

¦pªG¤£¥Îworksheet function,´N¥²¶·¥Îfor
ss

TOP

¦^´_ 3# sunnyso


   ¦bvbe¨½¥i¤£¥i¥H³o¼Ë¼g    for each i in [ index(A,5,0)]    ?(¬Ù¼gworksheetfunction)
lmh

TOP

¦^´_ 4# mhl9mhl9

No, I don't think so
ss

TOP

¦^´_ 5# sunnyso

you mean "¼g¦b­¶­±¤£·|¤£¦n" or "¥ÎActiveX¤£³Â·Ð"?
lmh

TOP

¦^´_ 5# sunnyso


    ¤£¦n·N«ä,§Ú·d¿ù©«¤l,À³¸Ó°Ý"¦bvbe¨½¤£¥i¥H³o¼Ë¼g    for each i in [ index(A,5,0)] ¶Ü?
lmh

TOP

¦^´_ 5# sunnyso


    ¦A·Q½Ð±Ð§A­Ó°ÝÃD,sunnyso,§Ú§â§Ú¼gªºexcelªF¦è³£§ï¦¨.xlsb®æ¦¡µ¹user,¦]¬°sizeÅܤp,open©Mclose¤S§Ö,¤S¤£¥Î¶O«l,¦ó¼Ö¦Ó¤£¬°©O?¦ý·|¤£·|¦³°ÝÃD,§Ú¹ê¦b¹ï¤£³Ò¦ÓÀòªºªF¦è¦³ÂI¾á¤ß,§A¨£¦hÃѼs,µ¹ÂI·N¨£?
lmh

TOP

ª`·Nexcel version §Y¥i
ss

TOP

¦^´_ 9# sunnyso


    thank you
lmh

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD