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

§Q¥ÎFind§ä¤é´Á¡A¥X²{¿ù»~!!

¦^´_ 1# hugh0620
A = A.Offset(0, 0).Row
µ¥¸¹¥kÃ䪺 A ©ó¤W¦æ³Q³]©w¦¨ Range ª«¥óÅܼơA¦Óµ¥¸¹¥ªÃ䪺 A ¬O«o¬O¥H¼Æ­ÈÅܼÆ(«ü¦VRow)§e²{¡A¥i¯à¬O¦¹³¯­z¦¡¥X²{¥Ù¬Þªº°ÝÃDÃöÁä¡C
¥t¥~Áٻݭn¦p8¼Óªº naruto018 ¤j»¡ªº Find ¶·¥[¼g­Y§ä¤£¨ì®Éªº¨¾§b¾÷¨î¡C

TOP

¦^´_ 25# hugh0620
³o¸Ì¦³¤@½g¤£ª¾¬O§_¦³À°§U¡H
https://excelmacromastery.com/excel-vba-find/#Using_SearchFormatwith_Find
½Ð¬Ý¡GUsing SearchFormat with Find ½g¤Î¨ä½d¨Ò
¨ä¤¤¦³¤@¥y¡G
Application.FindFormat.Clear
¥i²M°£«e¦¸³]©wªº Find Format

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD