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

[µo°Ý] ½Ð°Ý¦p¦ó§Q¥ÎDDE´£¨Ñªº®É¶¡¼Æ¾Ú©w´Á¬ö¿ý¦bexcel¬¡­¶Ã¯

Barry ¤j¤j±z¦n:

¨Ì·Ó±zªº«Øij­×§ï¦p¤U
¦ý«o¶]¥X¿ù»~°T®§



[attachimg]18740

Error.png (56.23 KB)

Error.png

TOP

¦^´_ 21# lawlu
©êºp¡Aend if §R°£¡C
¤H¥Í¥u¦³¤T¤Ñ¡A¥u¦³¬¡¦b¤µ¤Ñ³Ì½ñ¹ê

TOP

barrykuo¤j¤j:

1. ¤w±Nend if §R°£
2.µ{¦¡¬O¨S¦³¥X²{¿ù»~°T¡A¦ýÁÙ¬O¨S¦³¬ö¿ý¸ê®Æ
3.¤£ª¾¬O§_¦]±z¤§«e¦³´£¨ìdatarow = Sheets("yyyyyy").[c65536].End(xlUp).Row¸Ì­±ªºyyyyyy¶ñ¤W§A°O¿ýªº¬¡­¶Ã¯¦WºÙ

¦Ó§Ú±NÀɦW³]¬°"EURO"¡A ©Ò¥H§Ú±Nyyyyyy¶ñ¤WEURO¡A¤]´N¬O»¡¦p¤U:

datarow = Sheets("EURO").[c65536].End(xlUp).Row

¤~³y¦¨µLªkRUNµ{¦¡

·PÁ¦^´_

TOP

¦^´_ 23# lawlu
lawlu¤j¤j¡A§Ú«ö¦Û¤v²ßºD§ï¤Fµ{§Ç¡A³]©w5¬í°O¿ý¤@¦¸¨S¦³°ÝÃD¡A½Ð¦A¬Ý¬Ý¡C

¤H¥Í¥u¦³¤T¤Ñ¡A¥u¦³¬¡¦b¤µ¤Ñ³Ì½ñ¹ê

TOP

barrykuo¤j¤j

¨Ì«Øij­×§ï«á¡A¤w¸g¥i¥Hrun¤F
ÁÂÁ±z

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD