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

¦p¦ó¸Ñ¨M¦]®æ¦¡°ÝÃD¦Ó¥¼¯à·j´M¤é´Á

¦p¦ó¸Ñ¨M¦]®æ¦¡°ÝÃD¦Ó¥¼¯à·j´M¤é´Á

½Ð°Ý¦p¦ó·j´M¤é´Á
1. ·í·j´M¤é´Á®É, ¸g±`¦]¬°¤é´Á®æ¦¡°ÝÃD¦Ó¥¼¯à¥¿½T·j´M
¨Ò¦p·Q·j´Mªº¤é´Á¬O 01Nov2014, ¦ý¦]¬°®æ¦¡°ÝÃD, ·|§ä¤£¨ì01/11/2014 ,¬O§_­n±N®æ¦¡²Î¤@
2. ¥t¥~À³«Å§iÅܼƬ°Data«¬ºA¶Ü?
3. ·íÀɮפº©Ò¦³¤é´Á³£¨Ï¥Î¬Û¦P¤é´Á®æ¦¡,  À³¦p¦ó³]©w­n·j´Mªº¥Ø¼Ð®æ¦¡ ¬O ddmmmyyyy

½Ð¦h¦h«ü±Ð

¦^´_ 1# enoch
°Ý±o¤Ó¼Ò½k¡AªþÀɸÑÄÀ¤@¤U·|¤ñ¸û²M·¡¡C

1. ·íµM­n²Î¤@
2. ÅܼƬݧA«ç»ò¥Î¡A§Ú¤S¤£ª¾¹D§Aªº¨º­ÓÅܼƭn·F¹À..
    PS:®É¶¡ªº¸ê®Æ«¬ºA¬ODate
3. ¬Ý¤£À´¡A¬Æ»ò¬O  "³]©w­n·j´Mªº¥Ø¼Ð®æ¦¡¬O ddmmmyyyy"

TOP

¨Ò¦p­n·j´Mªº¤é´Á¬O 01Nov2014, ·í¸ê®Æ«¬ºA¬ODate ®É
¤£©ú¥Õ¦b·j®É·|§ï¤F«¬ºA¬° 01/11/2014, ³Ì²×­n³]©w¬° String ¤~¯à§ä¨ì

TOP

¦^´_ 3# enoch
B3 ¶ñ¤J2014/11/5¡A®æ¦¡§ï¬°ddmmmyyyy
Àx¦s®æÅã¥Ü05Nov2014


B5 ¶ñ¤J2014/11/5¡A®æ¦¡§ï¬°dd/mm/yyyy
Àx¦s®æÅã¥Ü05/11/2014


¿ï¨úB¾ãÄæ¡ACtrl+F ´M§ä  2014/11/5
B3©MB5³£·|§ä¨ì
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¤£¦n·N«ä, ªþ¤WÀɮװѦÒ
¦bÀɮפ¤·Q±N¦³Ãö¤é´Á¬Û¦Pªº¸ê®Æ§R°£,
½Ð¦h¦h«ü±Ð¨º¸Ì¥X¿ù

DelData.zip (11.56 KB)

TOP

¦^´_ 5# enoch
§A¶]§¹¬O¦³¿ù»~¶Ü? ÁÙ¬O¨S¦³§R°£±¼?
¥i¥H¸Õ¸Õ¬Ý§ï³o¸Ì
Target.Find(What:=FindText, LookIn:=xlFormulas, LookAt:=xlWhole,
   
LookIn °Ñ¼Æ¨Sµ¹®É·|¥Î¤W¦¸¨Ï¥Îªº­È
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

²×©óª¾¹D­ì¦], ¦hÁÂstillfish00­@¤ß¸Ñµª

TOP

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