§Q¥ÎFind§ä¤é´Á¡A¥X²{¿ù»~!!
- ©«¤l
- 163
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 170
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-5
- ³Ì«áµn¿ý
- 2022-7-20
|
¦^´_ 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 ¶·¥[¼gY§ä¤£¨ì®Éªº¨¾§b¾÷¨î¡C |
|
|
|
|
|
|
- ©«¤l
- 163
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 170
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-5
- ³Ì«áµn¿ý
- 2022-7-20
|
¦^´_ 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 |
|
|
|
|
|
|