ªð¦^¦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

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# starry1314


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

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD