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

[µo°Ý] ´£¨ú¦r¦ê¤º¼Æ¦r¤ñ¤j¤p

¦^´_ 1# wayne0303

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

¨ú¼Æ¦r.zip (50.98 KB)

TOP

¦^´_ 3# wayne0303

¤½¦¡¤£¤Ó·|¼g¥u¯à¼g¨ì³o¼Ë¤F¡Aµ{¦¡¤]¦³¤p­×§ï¡A½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

¨ú¼Æ¦r.1.zip (51.86 KB)

TOP

h¤jªº¤½¦¡¯uªº¦n¼F®`¡A¾Ç°_¨Ó¤F¡A·PÁ¤À¨É¡C

TOP

¦^´_ 11# ­ã´£³¡ªL

­ã¤j¡A½Ð±Ð¤@¤U Like "#"   ¬O¨ú¼Æ¦r¡A§Ú¬O¥ÎASCII§PÂ_¡A¨º¦pªG¬O¥u¨ú­^¤å¡A ­n¦p¦ó¼g Like ...
¥t¥~³oºØ¼gªk­n¦p¦ó¬d¨ì©Ò¦³¬ÛÃö¸ê°T(¦p¯S®í²Å¸¹¡B­^¤å¤j¼g...)¡A
¦]¬°ASCII¦³¬ÛÃö¸ê°T¡A¥u­n§ä¨ì´N¥i¥HÂ^¨ú¬ÛÃö¦r¡AÁÂÁÂ

TOP

¦^´_ 13# ­ã´£³¡ªL


·PÁ­ã¤j«ü¾É¡A¥t¥~­è­ègoogle ¤@¤U¡A¤À¨É¦h¤@­Ó¤¤¤å¼gªk¡AÁÂÁ¡C

MsgBox "¤¤" Like "[¤@-Æ~]"    '¤¤¤å¦r

TOP

¦^´_ 17# ­ã´£³¡ªL


¤¤¤å...¨S¦h¥h´ú¸Õ--¯S®í¦r/²Åé/¤é¥»¤¤¤å--·|¤£·|¦³§P¿ù
>> ¸g¹L´ú¸Õ¡A¯uªº¦³°ÝÃD¡AÁÂÁÂ

TOP

¦^´_ 21# wayne0303


    §Ú®³¤F§A¤§«eªºÀɮרӸաA§Ú²¾°Ê¤F¨Ó·½¸ê®Æªº¦ì¸m°õ¦æ·|¥X²{
>>¥i§_ªþ¤WÀɮסAÁÂÁÂ

TOP

¦^´_ 23# wayne0303


§ó§ï¦p¤U¡AÁÂÁÂ
Arr = Range([u3], [u65536].End(3))

TOP

¥»©«³Ì«á¥Ñ samwang ©ó 2021-9-2 14:11 ½s¿è

¦^´_ 26# wayne0303

Arr = Range([a11], [a65536].End(3)), ­×§ï¦p¤U¬õ¦r
Arr = Range([a11], [a11].End(4))

End(3) = End(xlUp)
End(4) = End(xlDown)

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD