¥X³f³æ¦X¨Ö¦C¦L¿é¥X°ÝÃD¡A¦³µLª½±µ¾Þ§@¤èªk¡A©Î»Ý±Ä¥ÎVBA¸Ñ¨M¡C
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
  
|
¥X³f³æ¦X¨Ö¦C¦L¿é¥X°ÝÃD¡A¦³µLª½±µ¾Þ§@¤èªk¡A©Î»Ý±Ä¥ÎVBA¸Ñ¨M¡C
²{¦³¥X³f³æ(¤@³æ¸¹¦³¦h¶µ²£«~n¿é¥X)¡A¸ÔSheet¡u¿é¥X¤º®e¡v
¦]¬°¥X³f·í®É¡A§Y»Ýn§Y®É¦L¥X¨Ó°eµ¹«È¤á¡C
Sheet ¤º®e»¡©ú
¡u¥X³f³æ¤º®e¡v¡Gq³æn¥X³fªº¤º®e
¡u¥X³f³æ«È¤á¡v¡Gq³æ¬O¨º¦ì«È¤áqÁʪº
¡u¿é¥X¤º®e¡v¡Gnµ¹Word¡B¦X¨Ö¦C¦L¿é¥X¥Îªº
°ÝÃD¦³3¡A¦p¤U¡A¤£¨D¯à°÷§¹¥þ¸Ñ¨M
1.¥i§_¾Þ§@ª½±µ®M¦L¥X³f³æ¸¹¡B«~¦W¡B¼Æ¶q¡B³æ»ù¡Bª÷ÃB¡A¦ý¦P¤@±i¥X³f³æ¡A¥u¦³¤@¦ìqÁʫȤá¡A©Ò¥H¥un¥X²{¤@¦¸¡C
2.¦pªG¦P®É¦³3±i¥X³f³æn¦L¡A¥i§_¨Ì¥X³f³æ¸¹¤£¦P®É¡A§PÂ_»Ýn´«¶¦C¦L¡C
3.¥i§_¦³·í¶¥X³f³æªº¦Xp¼Æ¥i¥H¦C¦L¤W¥h(³oÓ¦pªG¤£¦æ¡AÁÙ¥i¥H¦Û¤w¥[¹L¤â¼g¤W¥h)
1.ªº³¡¤À¤ñ¸û»Ýn°µ¡A¦]¬°¤â¼g¤£§Ö¡A®e©ö¿ù¡C
2.¦Ü¤£ÀÙ¡A¤À§å¦C¦L¤]ÁÙ¦n
¾ãÓ°ÝÃD¦³ÂIÃø«×¡A¦pªG¤£¯à¥þ³¡¸Ñ¨M¡A½Ð°Ý¦³µL¸ÑÃDªº¤è¦V«ü¾É¡A¤]«Ü·PÁ¡C |
-
-
¥X³f.zip
(10.86 KB)
|
|
|
|
|
|
- ©«¤l
- 9
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 21
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2016-3-19
- ³Ì«áµn¿ý
- 2017-11-24

|
¦^´_ 7# Hsieh
¶W¦n¥Îªº....®M¤@Ӫťժí´N¥i¥H¦L¥X©Ònªºªí³æ
¤ñ³sµ²¨ìWORD°µ¦X¨Ö¦C¦LÁÙÃÙ |
|
|
|
|
|
|
- ©«¤l
- 2
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- TAIWAN
- µù¥U®É¶¡
- 2015-9-14
- ³Ì«áµn¿ý
- 2017-3-20
|
§ä¤F¦n¤[,²×©ó§ä¨ìÃþ¦üªº¸Ñ¨M¤èªk
¯u¬O¨ü±Ð¤F~ |
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¦Ë
- µù¥U®É¶¡
- 2011-9-29
- ³Ì«áµn¿ý
- 2020-8-25
|
½Ð°Ýª©¥D¡G
Y¦C¦L¤@¦¡¤TÁp,¦p¥X³f³æ ªí®æ²¤¦³¤£¦P,¤º®e¤@¼Ë¦C¦L¤T±i ¤@±i¦¬°õÁp,¤@±i¯d©³Áp,¤@±i¦s¬d,¸Ó¦p¦óקï,ÁÂÁÂ! |
|
max
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
  
|
GBKEEª©¥D¡AÁÂÁ¡C³o¼Ë§Úª¾¹D³oÓ°}¦Cªº»yªk¤F¡C |
|
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
        
|
¦^´_ 12# Baracuda
¬O¤@ºû°}¦C, «D¤Gºû°}¦C.
- Sub Ex()
- Dim Ar(2), i%, y%, a
- Ar(0) = Array(1, 2, 3, 4)
- Ar(1) = Array("A", "B", "C", "D")
- Ar(2) = Array("¥Ò", "¤A", "¤þ", "¤B")
- For i = 0 To UBound(Ar)
- For y = 0 To UBound(Ar(i))
- [a1].Offset(i, y) = Ar(i)(y)
- Next
- Next
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
  
|
GBKEEª©¥D
¤@¯ë Array2ºû°}¦C¥Îªk¬OAr(i,2)¦ý³oùإΪº¬OAr(i)(2)¡C
³oÓ»yªk§Ú¨S¬Ý¹L¡A©Ò¥H·Q¸ò¥L½T©w¤@¤U¡C
ºô¸ô¤W§Ú¦³ Google ¹L¡A¶q¤Ó¤j¡A¤£®e©ö§ä³oÓ¯S©wªº»yªk¡C
Hsiehª©¥D¦³ÂI¬O¡u¤@©Û¥]¤@¸ô¡vªº¤è¦¡¡C |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
  
|
Hsieh¶W¯Åª©¥D§A¯uªº«Ü¯«¡A§Ú§â¾ãÓ¤º®e¬Ý§¹¤F¡C
§AªºVBA¡AÁÙ¦³¦Ò¼{¨ì¶W¹L5µ§¦C¦L¤Wªº°ÝÃD¡C
¨ä¥L¤@¨Ç½Ñ¦pn²Öp¡B®æ¦¡¡K³£ºâ¤p°ÝÃD¡C
§Aªº¸ê®Æ¤¤¡A¦³Ó¦a¤è§Ún½Ð±Ð§A
.Cells(r + 5, 2).Resize(, 5) =(Ar(i)(2), Ar(i)(3), Ar(i)(4), Ar(i)(5), Ar(i)(6))
³oÓ¦n¹³¬O2ºû°}¦Cªº¤è¦¡¡A§A¬O¤£¬O¥Î°}¦CAr()¥]°}¦Cªº¤è¦¡(¥t¥~ªº¤¸¯À2~5¡A0¬°qÁʫȤ᪺¦WºÙ¡A1¬O¥X³f³æ¸¹)¡C
³oӤ覡¦b³oùØ Work¡A¥u¬O§Ú¨S¬Ý¹L¦³¤H³o¼Ë¥Î¡C |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
  
|
Hsiehª©¥D¡G
§Ú¦³¸Õ¹L§AªºªF¦è¡A¸ê®Æ¥i¥H°µ¥X¨Ó¡CÁöµM§ÚÁÙ¤£¬O«Ü§¹¥þ©ú¥Õ¤º®e¡C
§Ú¼gªºVBA¤@©w¬O¨S¦³§Aªººë²¡C
ÁÂÁ§Aªº¦^µª¡A§Ú¬Ù¥h¤£¤Ö®É¶¡µo®i§Úªº VBA¡C |
|
|
|
|
|
|