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

±Ï§U!°õ¦æ¶¥¬q¿ù»~ "1004",½Ð¤º¬Ý ·PÁ¤F!

±Ï§U!°õ¦æ¶¥¬q¿ù»~ "1004",½Ð¤º¬Ý ·PÁ¤F!

¥»©«³Ì«á¥Ñ icestormerss ©ó 2011-8-13 14:57 ½s¿è

¥Ñ©ó»Ý­n ±N¤u§@ªí ½Æ»s ¦ýµo²{¦b½Æ»s¨ì¦¸¼Æ¤j¬ù5¨ì2 30¦¸®É(¤j³£¦b20¦¸¥ª¥k)´N·|²£¥Í¤@­Ó¿ù»~

¿ù»~:°õ¦æ¶¥¬q¿ù»~ "1004": class worksheetªºcopy¤èªk¥¢±Ñ

¤@¶}©l§Ú¥H¬°¬O§Ú¼g¿ù.µM«áµo²{¦n¹³¤£¬O §Ú´N¦n©_ªº¹êÅç.¥u­n§Úªº¤u§@ªí(­n½Æ»sªº)¤º®e¶V¦h(¹³¦³¤ñ¸û¹Ï)¦³®É¤j¬ù10¦¸¤§¤º´N·|¥X²{¿ù»~

ÀHªÌ§Ú§â¤u§@ªí¤º®e¶V²ºë¥¦¥X¿ùªº¦¸¼Æ´N¶V«á­±(§¹¥þªÅ¥Õªº¤u§@ªí§Ú¸Õ¹L¨ì600¦¸³£ÁÙ¤£·|¥X¿ù..)

µM¦Ó,¥u­n¥X¤F¿ù»~,§Ú­«¶}EXCEL«á,¿ù»~¤£¨£¤F,¦A­«¦æ°õ¦æµ{¦¡«á°ÝÃD¤@¼Ë¦s¦b,¥u¬O·|µo¥Í¿ù»~ªº¦¸¼Æ,¥i¯à¤SÅÜ°Ê(¤]³\­è¤~²Ä10¦¸¥X¿ù,³o¦¸´«20¦¸)


¤£ª¾¦³¨S¦³°ª¤â¯àÀ°§Ú¸Ñ¨M³o°ÝÃD?

§Ú¥u¬O·Q³æ¯Âªº½Æ»s¤u§@ªí¨ì³Ì«á¤@­Ó¦ì¸m¥h

­ì¥»¼gªº¬O
shtcount =worksheets.count
worksheets(1).copy after:=worksheets(shtcount)

-------------------------------------------------------------------------------------

§O¥Îcopy¡A¨t²Î°Å¶KïµLªk®e¯Ç¤Ó¦hªº¸ê®Æ¡C
§ï¦s¨ì°}¦C¤¤¡A¼g¤J·sªº¦ì¸m¡A´N¤£·|¦³³oºØ²{¶H¤F¡C

TOP

§O¥Îcopy¡A¨t²Î°Å¶KïµLªk®e¯Ç¤Ó¦hªº¸ê®Æ¡C
§ï¦s¨ì°}¦C¤¤¡A¼g¤J·sªº¦ì¸m¡A´N¤£·|¦³³oºØ²{¶H¤F¡C
oobird µoªí©ó 2011-8-13 10:59



¥u¦³À´¤@ÂIÂI°}¦C(´N¥uª¾¹D§â¼Æ¦r©Î¤å¦r¼g¤J°}¦C¦A¥Î°j°é¨ú¥X¤§Ãþ¦Ó¤w..),,¦ý§¹¥þ¤£ª¾­n«ç¶}©l¤U¤â §ï¦s¨ì°}¦C¤¤,¼g¤J·sªº¦ì¸m ¯à§_¼g¤@­Ó½d¦C©O ·P®¦~~!

TOP

¨ä¹êÁÙ¬O¬Ý¤£À´§Aªº°ÝÃD¡C
¬Ý§Aªºµ{¦¡½X¬O½Æ»s¨ì¦P¤@¬¡­¶Ã¯¡A¦³¦ó·N¸q¶Ü¡H
For i = 1 To 100
Worksheets(Array("¬d¸ßªÑ²¼")).Copy after:=Worksheets(2)
Next i
³æ¤@¤u§@ªí½Æ»s100¹M¡A¬°¤°»ò­n³o¼Ë¡H¦Ó¥B¬°¤°»ò­nArray("¬d¸ßªÑ²¼")¡H¬Ý¤£¥X¥ô¦ó·N¸q¡C

TOP

¥»©«³Ì«á¥Ñ icestormerss ©ó 2011-8-13 15:33 ½s¿è
¨ä¹êÁÙ¬O¬Ý¤£À´§Aªº°ÝÃD¡C
¬Ý§Aªºµ{¦¡½X¬O½Æ»s¨ì¦P¤@¬¡­¶Ã¯¡A¦³¦ó·N¸q¶Ü¡H
For i = 1 To 100
Worksheets ...
oobird µoªí©ó 2011-8-13 14:58


¥Î1¨ì100 ¥u¬O§Ú¥Î¨Ó´ú¨ì©³¨ì¦b²Ä´X±i·|¥X¿ù¦Ó¤w.§Úµo²{(¤µ¤Ñªº.)¥þ³£¬O¦b²Ä48¸ò49±i¤u§@ªí®É´N¤@©w¥X¿ù..

¥D­n¬O­n¤u§@ªí½Æ»s«á ¦A¥ÎWEB¬d¸ß(°t¦X¿é¤JªÑ¸¹,§ó·s«á(©Ò¥H½Æ»s«áªº¤u§@ªí¤º®e·|ÀHªÌªÑ¸¹¦ÓÅܰʦý°ò¥»®æ¦¡¬O¤@¼Ëªº)¦s°_¨Ó,
²{¦b ¥þ³£¬O¥d¦b¨º­Ó°ÝÃD¤W
(Åܦ¨¥u­n¥X¿ù..§Ú´N±oÃö±¼ ­«¶} µM«á¤S­n­«·s§ó·s«á¤~¯à¦A°µ«áÀYªº¤u§@)

¤£ª¾§Ú³o¼Ë»¡ À´¶Ü?©È§Ú»¡ªº¤£°÷²M·¡~~ ¯à¤£¯à½Ð§A¼g¤@­Ó²³æªº½d¨Ò §â¤u§@ªíA ½Æ»s«á ©ñ¤J°}¦C¤¤ ,¦A©ñ¨ì³Ì«á¤@­Ó¤u§@ªí¤§«á? ·PÁ©Ô~~

TOP

¦^´_ 5# icestormerss

¤u§@ªí½Æ»s¡A·|¥]§t®æ¦¡¡Bª«¥ó...µ¥µ¥
·í¤u§@ªí®æ¦¡¹L©ó½ÆÂø©Î¥e¥Î¤j¶q°Å¶K鷺®e¡A¼vÅT¨ì°O¾ÐÅé®e¶q´N·|¥X¿ù
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¯à¤£¯à½Ð§A¼g¤@­Ó²³æªº½d¨Ò §â¤u§@ªíA ½Æ»s«á ©ñ¤J°}¦C¤¤ ,¦A©ñ¨ì³Ì«á¤@­Ó¤u§@ªí¤§«á?
  1. Sub yy()
  2. Dim a, i%
  3. a = Sheet1.UsedRange
  4. For i = 1 To 100
  5. With Sheets.Add(After:=Sheets(Sheets.Count))
  6. .Name = "w" & i
  7. .[a1].Resize(UBound(a), UBound(a, 2)) = a
  8. End With
  9. Next
  10. End Sub
½Æ»s¥N½X

TOP

¯à¤£¯à½Ð§A¼g¤@­Ó²³æªº½d¨Ò §â¤u§@ªíA ½Æ»s«á ©ñ¤J°}¦C¤¤ ,¦A©ñ¨ì³Ì«á¤@­Ó¤u§@ªí¤§«á?
oobird µoªí©ó 2011-8-13 18:11



·PÁ¦U¦ìÀ°¦£ §Ú¥h¸Õ¬Ý¬Ý^^

TOP

¥»©«³Ì«á¥Ñ icestormerss ©ó 2011-8-13 19:56 ½s¿è

¤S¨Ó³Â·Ð¦U¦ì¤F

­è¤~§Ú¥h°õ¦æ ¥¦¥X²{ ¦b¨º¤@¦æ¥X¿ù(§Ú§¹¥þ¨S¦³§ï°Ê ,§Ú¶}¤@­Ó¥þ·sªÅ¥Õªº ¦A§âµ{¦¡½X ¶K¤W«á°õ¦æ)
½Ð°Ý ¨º­Ó°ÝÃD¬O¤°»ò·N«ä©O?

©Ç¤F.§Ú­è¤~¥h§â¤u§@ªí§R°£(¤£¤p¤ß³sSHEET2¸ò3(¹w³]ªº)³£§R¤F)¯«©_ªº¨Æµo¥Í¤F ©~µM¨S¦³¿ù»~¦Ó¶¶§Q°õ¦æ¤F...

Sub yy()
Dim a, i%
a = Sheet1.UsedRange
For i = 1 To 50
With Sheets.Add(After:=Sheets(Sheets.Count))
.Name = "w" & i
.[a1].Resize(UBound(a), UBound(a, 2)) = a  <<    °õ¦æ¶¥¬q¿ù»~ 1004:À³¥Îµ{¦¡©Îª«ª«©w¸q¤Wªº¿ù»~
                                       
End With
Next
End Sub

TOP

À³¸Ó¬O§Aªºsheet1¤u§@ªíµL¥ô¦ó¼Æ¾Ú¡C

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD