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

½Ð°Ý¥¨¶°µ{¦¡¦³¿ù»~¶Ü

½Ð°Ý¥¨¶°µ{¦¡¦³¿ù»~¶Ü

½Ð°Ý~~ªþ¥óÀÉ®×°õ¦æ¥¨¶°®É¬°¦ó·|±NAIÄæ¦ì¥H¥~ªº§R°£±¼
¦Ó¥B¥X²{¸ê®Æ¨«¦ì
¦ý¥u­n±NAK  AP  AQÄæ¦ì¸ê®Æ§R°£°õ¦æ¥¨¶°´N¥¿±`¡H

1489.zip (64.71 KB)

¦^´_ 1# lone_tiger0303


            Rng.Delete shift:=xlShiftUp
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

shift:=xlShiftUp   ³o¬O«ü¦ó·N«ä©O

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-8-10 17:29 ½s¿è

¦^´_ 3# lone_tiger0303
½Ð ¬d¬Ý Delete ªº»¡©ú
§A³o°ÝÃD¦³ÂI©_©Ç, Delete ¨S¥[°Ñ¼Æ®É¹w³]¬O¤U¤èÀx¦s®æ¤W²¾
¬°¦ó§A³o¨Ò¤l·|¬O¥k°¼ªº Àx¦s®æ¥ª²¾,
Ãø¹D¬O7¤ë·|µo¥Íªº¬O¶Ü?

TOP

·PÁÂGBKEE~~
§Ú­n»°§Ö¦^¥h«ô«ô

TOP

¦^´_ 4# GBKEE

¾ã¦C§R°£¹w³]¬O¦V¤W
¦ýÀx¦s®æ§R°£EXCEL·|¨Ì¾Ú½d³ò§Îª¬¨M©w
Shift ¿ï¥Î Variant ¥u¯à»P Range ª«¥ó¤@°_¨Ï¥Î¡C·|«ü©w¦p¦ó²¾°Ê¨ä¥LÀx¦s®æ¥H¶ñ¸É§R°£ªºÀx¦s®æ¡C¥i¥H¬°¤U¦C¨ä¤¤¤@­Ó XlDeleteShiftDirection ±`¼Æ¡GxlShiftToLeft ©Î xlShiftUp¡C¦pªG¬Ù²¤³o­Ó¤Þ¼Æ¡A«h Microsoft Excel ·|®Ú¾Ú½d³òªº§Îª¬¨Ó¨M©w¡C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh
«h Microsoft Excel ·|®Ú¾Ú½d³òªº§Îª¬¨Ó¨M©w
¦p¦ó¨M©w¥i»¡©ú¤@¤U¶Ü?

TOP

EXCEL»¡©ú¤W¥u»¡"¥¼«ü©w®É«h Microsoft Excel ·|®Ú¾Ú½d³òªº§Îª¬¨Ó¨M©w"
¨Sªá¤@µf¤u¤Ò¥h´ú¸Õ«ÜÃøª¾¹D¥Lªº®Ú¾Ú½d³òªº§Îª¬¬O«ç»ò¸ò¾Úªº¡C
¤£¹LDELETE¤U©Ô¿ï¶µ¤¤¡A¥k¤èÀx¦s®æ¥ª²¾±Æ¦b²Ä¤@¦ì¡AÀ³¸ÓÁÙ¬O³o­ÓÀu¥ýªº¡C

TOP

¦^´_ 7# GBKEE

¨Ì§Ú¸gÅç¡A©Ò¿×¨Ì½d³ò§PÂ_À³¬O«ü¾ãÄæ©Î¾ã¦C®Éªº±¡ªp
¦]¬°¾ãÄæ©Î¾ã¦C¤~¯à¤£ºÞ¨Ï¥ÎªÌªº·N¨£¡Aª½±µ¾ã¦C¦V¤W¡A¾ãÄæ¦V¥ª
­Y¬°³¡¤ÀÀx¦s®æ«h¬°¹w³]¦V¥ª¡AµM«á¥Ñ¨Ï¥ÎªÌ¨Ì»Ý­n¿ï¾Ü
¬G¦¹¡A¾ã¦C©Î¾ãÄæ¥i¤£¶·¦¹°Ñ¼Æ¡A¦ý³¡¤ÀÀx¦s®æ«h»Ý°Ñ¼Æ¤~¯à¨Ì·Ó¨Ï¥ÎªÌ»Ý¨D°Ê§@
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# oobird
¦^´_ 9# Hsieh
¦h¨Ç¨â¦ì¶Wª©µªÂÐ:
¼Ó¥D»¡¦ý¥u­n±NAK  AP  AQÄæ¦ì¸ê®Æ§R°£°õ¦æ¥¨¶°´N¥¿±`¡H [¤U¤èÀx¦s®æ¤W²¾]
¼Ó¥DªþÀɪº½d³ò 114¦C35Äæ,¸g§Ú´ú¸Õ½d³òÁY¨ì<=35¦C®É¤£ºÞ AK  AP  AQÄæ¦ì¬O§_¦³¸ê®Æ ³£¬O [¤U¤èÀx¦s®æ¤W²¾]
Microsoft Excel ·|®Ú¾Ú½d³òªº§Îª¬¨Ó¨M©w ,¥i¯à´N¬O¦p¦¹§a!

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD