±Ï§U!°õ¦æ¶¥¬q¿ù»~ "1004",½Ð¤º¬Ý ·PÁ¤F!
- ©«¤l
- 16
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 23
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-13
- ³Ì«áµn¿ý
- 2011-8-19
|
±Ï§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©_ªº¹êÅç.¥un§Úªº¤u§@ªí(n½Æ»sªº)¤º®e¶V¦h(¹³¦³¤ñ¸û¹Ï)¦³®É¤j¬ù10¦¸¤§¤º´N·|¥X²{¿ù»~
ÀHªÌ§Ú§â¤u§@ªí¤º®e¶V²ºë¥¦¥X¿ùªº¦¸¼Æ´N¶V«á±(§¹¥þªÅ¥Õªº¤u§@ªí§Ú¸Õ¹L¨ì600¦¸³£ÁÙ¤£·|¥X¿ù..)
µM¦Ó,¥un¥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)
------------------------------------------------------------------------------------- |
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
§O¥Îcopy¡A¨t²Î°Å¶KïµLªk®e¯Ç¤Ó¦hªº¸ê®Æ¡C
§ï¦s¨ì°}¦C¤¤¡A¼g¤J·sªº¦ì¸m¡A´N¤£·|¦³³oºØ²{¶H¤F¡C |
|
|
|
|
|
|
- ©«¤l
- 16
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 23
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-13
- ³Ì«áµn¿ý
- 2011-8-19
|
§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®¦~~! |
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
¨ä¹êÁÙ¬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 |
|
|
|
|
|
|
- ©«¤l
- 16
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 23
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-13
- ³Ì«áµn¿ý
- 2011-8-19
|
¥»©«³Ì«á¥Ñ 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¿ù..
¥Dn¬On¤u§@ªí½Æ»s«á ¦A¥ÎWEB¬d¸ß(°t¦X¿é¤JªÑ¸¹,§ó·s«á(©Ò¥H½Æ»s«áªº¤u§@ªí¤º®e·|ÀHªÌªÑ¸¹¦ÓÅܰʦý°ò¥»®æ¦¡¬O¤@¼Ëªº)¦s°_¨Ó,
²{¦b ¥þ³£¬O¥d¦b¨ºÓ°ÝÃD¤W
(Åܦ¨¥un¥X¿ù..§Ú´N±oÃö±¼ «¶} µM«á¤Sn«·s§ó·s«á¤~¯à¦A°µ«áÀYªº¤u§@)
¤£ª¾§Ú³o¼Ë»¡ À´¶Ü?©È§Ú»¡ªº¤£°÷²M·¡~~ ¯à¤£¯à½Ð§A¼g¤@Ó²³æªº½d¨Ò §â¤u§@ªíA ½Æ»s«á ©ñ¤J°}¦C¤¤ ,¦A©ñ¨ì³Ì«á¤@Ó¤u§@ªí¤§«á? ·PÁ©Ô~~ |
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
¯à¤£¯à½Ð§A¼g¤@Ó²³æªº½d¨Ò §â¤u§@ªíA ½Æ»s«á ©ñ¤J°}¦C¤¤ ,¦A©ñ¨ì³Ì«á¤@Ó¤u§@ªí¤§«á?- Sub yy()
- Dim a, i%
- a = Sheet1.UsedRange
- For i = 1 To 100
- With Sheets.Add(After:=Sheets(Sheets.Count))
- .Name = "w" & i
- .[a1].Resize(UBound(a), UBound(a, 2)) = a
- End With
- Next
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 16
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 23
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-13
- ³Ì«áµn¿ý
- 2011-8-19
|
¯à¤£¯à½Ð§A¼g¤@Ó²³æªº½d¨Ò §â¤u§@ªíA ½Æ»s«á ©ñ¤J°}¦C¤¤ ,¦A©ñ¨ì³Ì«á¤@Ó¤u§@ªí¤§«á?
oobird µoªí©ó 2011-8-13 18:11
·PÁ¦U¦ìÀ°¦£ §Ú¥h¸Õ¬Ý¬Ý^^ |
|
|
|
|
|
|
- ©«¤l
- 16
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 23
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-13
- ³Ì«áµn¿ý
- 2011-8-19
|
¥»©«³Ì«á¥Ñ 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 |
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
À³¸Ó¬O§Aªºsheet1¤u§@ªíµL¥ô¦ó¼Æ¾Ú¡C |
|
|
|
|
|
|