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

Excelµ{¦¡¬O¥Î¨Ó°µ¤°»ò

Excelµ{¦¡¬O¥Î¨Ó°µ¤°»ò

³Ìªñ¨ì¤@¶¡¤½¥q¡A±`·|¥Î¨ìExcel§Ú¤§«e¦³¦b¸É²ß¯Z¾Ç¹L¡A¦ý¨ì³o­Óºô¯¸µo²{­ì¨ÓÁÙ¦³Excelµ{¦¡¡A
³o¤j·§³£¥Î¦b­þ¡A¦pªG§Ú·Q¾Ç­n±q­þÃä¶}©l¾Ç¡A§Ú¦b·Q¦h¾Ç¤@ÂI¤]³\·|§â¤u§@°µ±o§ó¦n¡C
sky

¦³»Ý¨D¤~¦³°Ê¾÷  ¦³°Ê¾÷¤~¦³°Ê¤O¥h¾Ç²ß!
§Ú¹ïEXCEL­ì¨Ó¤]¤î©ó²³æªº¸ê®Æ¹Bºâ
¦ýµo²{¥i¤w¨ú¥Î¨é°ÓªºDDE¨Ó°µ£¸¨Ç¦Û¤v¯S§OªºªÑ²¼¹Bºâ«á
´N·Q¿ìªkÅý¦Û¤v¤Jªù¤F
ÁöÁÙ¤£¬O«ÜÀ´µ{¦¡ªº¼¶¼g¹Lµ{  ¦ýÂǥѽ׾½d¨Ò  «÷«÷´ê´ê©M¦b½×¾Â±o¨ì«e½úªº¼ö¤ßÀ°¦£
¤]«j±j«÷¥X¦Û¤vªºEXCEL¹B¥Î!
¦³°Ê¾÷  ¦h°Ý  ¦h¸Õ  ´N·|¤Jªù

TOP

¾Ç·|EXCEL¥i¥H°µ«Ü¦h¨Æ~
¹³³øªí§e²{,¸ê®Æ­p/¸Õ/Åçºâ,¤ÀªR³ø§i,µ{¦¡½sÄ¡,«Ø¥ß¼Ò«¬....µ¥
¥Î³~ÁÙÆZ¼sªº,¤]¥i¥H¥[´£¤É¤u§@®Ä²v
­Ó¤Hı±o¦bOffice®a±Ú¤¤¹ê¥Î©Ê³Ì°ª!

TOP

¦^´_ 17# qwer7632


    §Ú­è¶}©l¬O¶R°ò¥»ªº®Ñ¾Ç
   ¿ý»s¦n·|±Nµ{¦¡½X¶K¨ìEXCEL¸Ì­±µM«á¤ÀÃþ
   ¤U¦¸¥Î¨ì®É§Ñ¤F«ç»ò¼g´Nª½±µ¥´¶}EXCEL¬d
   ³o¼Ë¥i¥H§Ö¨Ç
   ²{¦b¦A¦^¥h¬Ý§Ú¥H«e°OªºªF¦è
   ¯uªº¬O«Ü²Ê²L
   ¤£¹L³o¼Ë«Ü¦³¦¨´N·P
   
   ¨C­Ó¤H¾Ç²ß¤è¦¡³£¤£¤@¼Ë
   ­è¶}©l«Ü¦h«Ü²³æªºªF¦è³£¥i¥H·í§@¥Ø¼Ð
   ºCºCªº´N·|·Q­n¹³°ª¤â¤@¼Ë
   
   ¥u¦³½ñ¥X¥h¤~·|¾Ç¨ì
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 17# qwer7632

·|§Ñ ¬O¥¿±`..
¾Ç¹q¸£¬ÛÃöªF¦è(³nÅé¡BµwÅé¡Bµ{¦¡) ¥»¨Ó´N¬O¦Û¤v·Q¾Ç¤~·|¾Ç±o¦n
±j¹G§A¾Ç ¤£¨£ªº¬O¦n¨Æ
©È§Ñ°O ¥i¥H¦b§A¥´ªºµ{¦¡½X¤º+µùªþ°O
¤@¨Ó¥i¥H·í¼Ò¶ô¥Î
¤G¨Ó ¥i¥H¤Ö¥´«Ü¦h
1

µû¤À¤H¼Æ

TOP

§Ú¦³¾Ç¹L«Ü¦hªF¦è¡A¦ý¨S¦³¦Ñ®v¾Çªº´NµLªk«Ü²`
¤£±`¥Î¤S·|§Ñ¦n¶Ë¸£µ¬
sky

TOP

¦^´_ 14# qwer7632
¿ý»s¥¨¶°´Nµ¥©ó¬O§â§Aªº¾Þ§@Âà´«¦¨VBA»y¨¥
©Ò¥H¿ý»s§¹¦¨«áªº»yªk§A­n°t¦X§Aªº¾Þ§@¬yµ{¥h¤F¸Ñ³o¨Ç«ü¥O
¦A°t¦XF8³v¦æ¡A¤@¦æ¤@¦æªº°õ¦æµ{¦¡¡A°t¦X¤u§@ªí¤ºªºÅܤơA´Nª¾¹D¨º¤@¦æµ{¦¡ªº¥\¥Î
¹J¨ì¤£¤F¸Ñªº«ü¥O¡A±N·Æ¹«´å¼Ð°±¦b¸Ó«ü¥O¤W¡A«ö¤UF1´N¯à¬d¸ß¸Ó«ü¥Oªº¥Îªk
³o¬OEXCEL VBA®e©ö¤J¤âªº¥D­n­ì¦]
¨ä¥L°j°é¡B§PÂ_¦¡¡B¤@¨Ç³¯­z¦¡»yªk³£¬O©T©w¥Îªk¡A¥u¬O³o¨Ç­nÆF¬¡¹B¥Î¡A´N­n¾a¦Û¤v«ä¦Ò¤F¡C
§Ú±`¤ñ³ë¾Ç²ßVBA´N¹³°ê¤¤®É¾Ç­^¤å¡AVBA»y¨¥´N¸ò­^¤å¤@¼Ë¡A¨C­Ó«ü¥O´N¬O³æ¦r¡A»yªk´N¬O­^¤å¤åªk
¹q¸£¬O¤@¦ì¬ü°ê¤H¡A·í§Ú­Ì­n¥Î­^¤å¸ò¬ü°ê¤H·¾³q¡A´N­n³z¹L¬y§Qªº­^¤å¡A­n¦³¬y§Qªº­^¤å´N­n»{Ãѫܦh³æ¦r¡A
ºë³q¤åªk¡A¤£Â_½m²ß»¡¡A¤~¯à»¡¥X¤@¤f¬y§Q­^¤å¡C
©Ò¥H¡A¾Ç²ßVBA¤]¬O¦p¦¹¡A«ü¥O(³æ¦r)»{ÃѶV¦h¡A¤åªk(»yªk)­n¥¿½T¡A¤f¾¦(ÅÞ¿è)­n²M·¡¡A§ä¥~°ê¤H¦h½m²ß(¶Ô½m²ß)
³o¬O¾Ç²ßVBAªº¤£¤Gªkªù¡C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 14# qwer7632

¾Çµ{¦¡¥»¨Ó´N¤£¬O¥ó®e©öªº¨Æ¡A¥h³Õ«È¨Ó§ä¤@¨Ç¤é¥»¤H¼gªºvba®Ñ¡A¤@¨B¤@¸}¦Lªº¬ã¨s§a¡A¤]¬O¾Ç¼gµ{¦¡¤~Åý§Ú¾Ç·|¤@¨B¤@¸}¦Lªººë¯«¡C

TOP

¦^´_ 13# yagami12th

§Ú·|¥Î¤@¨Ç¥¨¶°¡A¦ý¦b¶Ã¤C¤KÁVªº®æ¦¡¤UÁÙ¬O¥u¯à°Å¤U¶K¡A³o¤~¬O³Â·Ðªº¦a¤è
sky

TOP

¦^´_ 1# qwer7632

·íªì¬O¦Û¤w·Q°µ¤@¨Ç¦¨«~¡A©Ò¥H¦³¤@°ï¼Æ¾Ú­n¦Û°Ê³B²z¡A¤~¶}±Ò¤Fvbaªº¾Ç²ß¤§¸ô¡A¥i¥H¥ý±q¿ý»s¥¨¶°¶}©l¾Ç¡C

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD