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

[µo°Ý] ½Ð±Ð¨Ï¥Îevaluate®É¡A¦p¦ó³]©w¤u§@ªíÅܼÆ

[µo°Ý] ½Ð±Ð¨Ï¥Îevaluate®É¡A¦p¦ó³]©w¤u§@ªíÅܼÆ

½Ð±Ð¨Ï¥Îevaluate®É¡A¤u§@ªí¦WºÙ¬°"ªÅ¥Õ"®É¡A¥i¥¿±`°õ¦æ¡G

Range("q" & Z) = Evaluate("ADDRESS(MATCH(""NOTES"", ªÅ¥Õ!A:A,0),1,4)")


¦pªG¤u§@ªí¦WºÙ³]©w¬°ÅܼƮɡA
a = ActiveSheet.Name
Range("q" & Z) = Evaluate("ADDRESS(MATCH(""NOTES"", a!A:A,0),1,4)")

·|¥X²{¿ù»~2023¡A½Ð°Ý¸Ó¦p¦ó­×¥¿©O¡H

¦^´_ 1# takeshilin88


    Sub test()
a = ActiveSheet.Name
Range("q" & Z) = Evaluate("ADDRESS(MATCH(""NOTES""," & a & "!A:A,0),1,4)")
End Sub
µ{¦¡¤À¨É ¡Ð·j´M partylin_µ{¦¡¾Ç²ßÀç
¡Ðhttps://www.partylin.com

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Î http://blog.xuite.net/hcm19522/twblog[img][/img]
¤w¦¬¶°7000½g EXCEL¨ç¼Æ

TOP

¦^´_ 2# starry1314


    ÁÂÁÂstarry1314¤j¤j¡A
    ­ì¨Ó¬O¥Î"&ÅܼÆ&"´N¥i¥H¤F¡A
    ²×©ó¸Ñ´b¤F¡A
    ·PÁÂ~~~

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD