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

[µo°Ý] ½Ð°Ý¦p¦ó³]©wExcel¦Û°Ê§ì¨ú¤G¶i¦ì¸ê®Æ

[µo°Ý] ½Ð°Ý¦p¦ó³]©wExcel¦Û°Ê§ì¨ú¤G¶i¦ì¸ê®Æ

½Ð°Ý¦p¦ó³]©wExcel¦Û°Ê§ì¨ú¤G¶i¦ì¸ê®Æ
¸Ô²Ó»¡©ú¦pªþ¥ó©Ò¥Ü

½Ð°Ý¦p¦ó³]©wExcel¦Û°Ê§ì¨ú¤G¶i¦ì¸ê®Æ.rar (494.82 KB)

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2022-1-27 05:23 ½s¿è

¦^´_ 1# jeff5424

1.¬ö¿ýA.fnc »P ¬ö¿ýB.Fnc »Ý­n¸òÀɮשñ¦b¦P­Ó¸ê®Æ§¨

2.»Ý­n¥ýÂIÀ»«ö¶s ¤~·|§ó·s¸ê®Æ  ¥Ø«e¥u¦³³]©w §ó·s ¬ö¿ýB.Fnc ªº¸ê®Æ

3.§ó·s¹L«á ¤~¯à¨Ï¥Î =findLocªº¥\¯à

vba¤j­P¬yµ{
(¶×¤J¸ê®Æ)
1.¥Îbyte¼Ò¦¡ ¶}±Ò.fncÀÉ®×
2.³Ðbyte°}¦C
3.byte¸ê®Æ ¶×¤J°}¦C
4.byte°}¦C¤ºªº¸ê®Æ  Âà´«¤å¦r¸ê®Æ10¶i¦ì  ¦Ü ·s³Ð¤å¦r°}¦C
5.Âà´«¦¨2¶i¦ì ©ñ¤J·s³Ð¤å¦r°}¦C  ©ñ¤Jto2¤u§@ªí
6.Âà´«¦¨16¶i¦ì ©ñ¤J·s³Ð¤å¦r°}¦C   ©ñ¤Jto16¤u§@ªí

(=findLoc)
1.¤Á¦r  ¥kÃä¤@¦ì ¸ò ¨ä¥L¦r
2.¬d¸ßto16ªí.aÄæ
3.§ä¨ìrow¦ì
4.§ä¨ìÄæ¦ì
5.¶Ç¦^findLoc

½Ð°Ý¦p¦ó³]©wExcel¦Û°Ê§ì¨ú¤G¶i¦ì¸ê®Æ.zip (688.77 KB)

TOP

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2022-1-27 18:58 ½s¿è

¦^´_ 1# jeff5424


    ¦³¨Ç³Æµù ¸ò ¸ê°T¥´¿ù¤F ©Ò¥H§ó·s ­«µo¤@¹M

½Ð°Ý¦p¦ó³]©wExcel¦Û°Ê§ì¨ú¤G¶i¦ì¸ê®Æ.zip (668.24 KB)

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD