½Ð°Ý¤Gºû°}¦C¨ú§½³¡¸ê®Æ¤èªk
- ©«¤l
- 32
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2019-4-28
- ³Ì«áµn¿ý
- 2021-7-6
|
½Ð°Ý¤Gºû°}¦C¨ú§½³¡¸ê®Æ¤èªk
¦U¦ì¤j¤j
¤p§Ì§Ú¦³Ó¤Gºû°}¦C¨ú§½³¡¸ê®Æªº°ÝÃD , ·Q½Ð±Ð¦U¦ì°ª¤â
§Úªº¤Gºû°}¦C myarray ¬O±q myarray(1,1) ~ myarray(10,10)
§Ún§â°}¦C³¡¥÷¸ê®Æ¼g¤JÀx¦s®æ , myarray(5,5) ~ myarray(7,7) ¼g¤JCells(5, 10) ~ Cells(7, 12)
¾ãÓarray¼g¤JÀx¦s®æ ©Î¬O ³æ¤@¦ì¸m¼g¤JÀx¦s®æ¤è¦¡¥i¥H
.Cells(5, 10).Resize( 10 , 10) = myarray ......... ¾ãÓarray ¼g¤J , ¥¿½T
.Cells(8, 5) = myarray(5, 5) ......... ³æ¤@¦ì¸m¼g¤J , ¥¿½T
¦ý¬O¤U±³oºØ¼gªk·|¥X²{¿ù»~
.Cells(5, 10).Resize(3, 3) = Range(myarray(2, 2), myarray(4, 4)) ......... ¿ù»~
°£¤F¼gÓ°j°é¤è¦¡¥~, ¦³¨S¦³¤ñ¸û²³æªº¤è¦¡?
·PÁ¤À¨É ~ |
|
MLB
|
|
|
|
|
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 273
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2016
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2019-9-6
- ³Ì«áµn¿ý
- 2024-11-21
|
¸Õ¸Õ:
.Cells(5, 10).Resize(3, 3)= Application.Index(myarray, [row(2:4)], [transpose(row(2:4))]) |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2019-4-28
- ³Ì«áµn¿ý
- 2021-7-6
|
·PÁÂJasnH¤j¤jªº«ü¾É
§Ú¸Õ¹L¤F, ¨S¦³°ÝÃD, ¤ñ°_§Úì¥ý¥Îªºfor°j°é¤è¦¡Â²¼ä¦h¤F
for i = 1 to 3
for j = 1 to 3
cells(4+j , 9+i) = myarray(2+j, 2 + i)
next
next
¥u¬O§Ú¸Õ¹L§â
[transpose(row(2:4))] §ï¦¨ [column(2:4)] , ¬°¦ó¶]¥X¨Óµ²ªG·|¤£¤@¼Ë©O?
.Cells(5, 10).Resize(3, 3)= Application.Index(myarray, [row(2:4)], [column(2:4)]) |
|
MLB
|
|
|
|
|