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

½Ð°Ý¤Gºû°}¦C¨ú§½³¡¸ê®Æ¤èªk

½Ð°Ý¤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

¸Õ¸Õ:
.Cells(5, 10).Resize(3, 3)= Application.Index(myarray, [row(2:4)], [transpose(row(2:4))])

TOP

·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

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD