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

¦³®É­Ô·|¥X²{ªº¿ù»~

¦³®É­Ô·|¥X²{ªº¿ù»~

·Q½Ð°Ý¤@¤U¡A¦³®É­Ô§Úªºµ{¦¡½X¦b°õ¦æªº®É­Ô³£¨S¦³°ÝÃD¡A¦ý¬O¦pªG§Ú¶}¤F¤Ó¦h¨ä¥¦ªºexcel·|¥X²{°}¦C¤Þ©Ò¶W¥X½d³òªº¿ù»~(¨C¦¸¿ùªº¦a¤è³£¤£¤@¼Ë).......¦³ªº¹q¸£«ç»ò·d¤]³£¨S°ÝÃD¡A¦³ªº´N·|¡C
½Ð°Ý³oºØ"°}¦C¤Þ©Ò¶W¥X½d³òªº¿ù»~"¿ù»~·|¸ò¹q¸£®Ä¯à¦³Ãö«Y¶Ü?

¹³¬O­è¥X²{¦b
activeworbook.sheet("¦WºÙ").cells().delete

³o¥y¸Ü§Ú«ç»ò³£¬Ý¤£¥X°ÝÃD...¦³®É­Ô¶]¤]¨S°ÝÃD¡A¦³®É­Ô´N·|¥X²{¿ù»~¾ã­Ó«D±`§xÂZ¡A¦ý¬O¤SÀˬd¤£¥X¿ù»~¡A¤£ª¾¨ì¦U¦ì¥ý¶i¥i¬°§Ú¸Ñµª¶Ü?

¦^´_ 1# snakei14702
activeworbook.Sheet("¦WºÙ").Cells().Delete

»yªk¿ù»~¤F,¸Õ¸Õ¬Ý
  1. ActiveWorkbook.Sheets("¦WºÙ").Cells.Delete
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE


    ÁÂÁª©¥D¡A¨º½Ð°Ý¬°¤°»ò³o¼Ë¦³®É­Ô·|¿ù»~¦³®É­Ô¤£·|©O?

TOP

¦^´_ 1# snakei14702

    activeworbook.Sheet("Sheet1").Cells().Delete    '¿ù»~
    ActiveWorkbook.Sheets("Sheet1").Cells().Delete  '¥¿½T
    ActiveWorkbook.Sheets("Sheet1").Cells.Delete    '¥¿½T
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# snakei14702

activeworbook.Sheet("¦WºÙ").Cells().Delete
³oµ{¦¡½X»yªk¿ù»~,µ{¦¡°õ¦æ¨ì³o¦æµ{¦¡½X¤@©w·|¦³¿ù»~²£¥Íªº.¤£·|®É¦³®ÉµLªº.
¬°¦ó¦p¦¹­n¬Ý§¹¾ãªºµ{§Ç¬O¦p¦ó¼g.
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

ÁÂÁ¨â¦ìª©¥D¡A¤£¹L§ÚÀ³¸Ó¬Okey¤JµL»~ªº..ActiveWorkbook.Sheets("¦WºÙ").Cells().Delete ¡A«D±`©êºp¤p§Ì¤â´Ý¦bµo°Ý®ÉKEY¿ù¡A¤£¹L¬Q¤Ñ¤S¥i¥H¶]...µM«á«e¤Ñ¤S¤£¯à¶]= =©ú©ú³£¬O¦P¤@°¦µ{¦¡½X¡A¥u­n¦h¶}´X­Óexcelµ{¦¡½X´N·|¥X²{"°}¦C¤Þ©Ò¶W¥X½d³òªº¿ù»~"...³oºØ¸Þ²§ªº¿ù»~...¤£ª¾¹D¬O¤£¬O¦]¬°µ{¦¡·|¤£¤p¤ßŪ¨ì§Oªºworkbook¦P¦Wªº­¶ÅÒ©O?

TOP

¦^´_ 6# snakei14702

¥u­n¦h¶}´X­Óexcelµ{¦¡½X´N·|¥X²{"°}¦C¤Þ©Ò¶W¥X½d³òªº¿ù»~"...³oºØ¸Þ²§ªº¿ù»~

ActiveWorkbook                    §@¥Î¤¤ªº¬¡­¶Ã¯
ThisWorkbook                       µ{¦¡½X¼Ò²Õ©Ò¦bªº¬¡­¶Ã¯
Workbooks ("¬¡­¶Ã¯¦WºÙ")   «ü©wªº¬¡­¶Ã¯

"°}¦C¤Þ©Ò¶W¥X½d³òªº¿ù»~" ,¨S¦³©Ò«ü©w¦WºÙªº¿ù»~
ActiveWorkbook(§@¥Î¤¤ªº¬¡­¶Ã¯)ªº¤u§@ªí¤¤¦WºÙ¨S¦³"¦WºÙ" ³o¤u§@ªí
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2016-6-22 05:58 ½s¿è

¦^´_ 6# snakei14702
§A±N¦³°ÝÃDÀɮפW¶Ç´ú¸Õ¡A
¤£´N¤@¤Á³£ªï¤b¦Ó¸Ñ¤F¶Ü¡H

TOP

¤£¦n·N«ä³Â·Ð¦U¦ì«e½ú¤F~ §Ú±N§Úªºµ{¦¡½X§ï¦¨thisworkbook¬Ý¬Ý·|¤£·|¦³§ïµ½¡C

¥t¥~ÁÂÁÂc_c_lai ¤£¹L¦]¬°¸Ì­±Ápµ²¨ì«È¤áªº¸ê®Æ¤~¯à¶]¡A©Ò¥H¤p§Ì§Ú¤£´±¤W¶Ç~¯u¤£¦n·N«ä

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD