- ©«¤l
- 11
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 21
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2011
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-5-5
- ³Ì«áµn¿ý
- 2015-6-27
|
¥»©«³Ì«á¥Ñ mpegwmvavi ©ó 2015-6-21 23:44 ½s¿è
¦^´_ 7# PKKO
§Ú·Q¤£¨ì¤@¦¸©Ê¸m¤Jªº¤èªk,
¤£¹L¤@±ø¤@±ø(ª½©Î¾î)©ñ¶i¥h¬O°µ±o¨ìªº
¤èªk¬O¥ÎIndex³oÓ¤u§@ªí¨ç¼Æ
¤£¹LÁÙ¬On°j°é¤T¦¸,¾¨ºÞ¦p¦¹,¤ñ°j°ém*n¦¸n§Ö±o¦h¤F
For j=3 to 5
Cells(1,j-2).Resize(10-3,1)=Application.Index(AA,0,j)
Next
°Ñ¦Òºô¯¸:
https://usefulgyaan.wordpress.com/2013/06/12/vba-trick-of-the-week-slicing-an-array-without-loop-application-index/ |
|