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

[µo°Ý] ½Ð±Ð¤@­Óvba resize ªº¥Îªk?

[µo°Ý] ½Ð±Ð¤@­Óvba resize ªº¥Îªk?

¤p§Ì³Ìªñ­è¾Çexcel vba ¹J¨ì¤@­Óresizeªº°ÝÃD,·Q½Ð°ª¤â±Ð¤@¤U
§Ú¦³¤@­Ó¼Æ²Õarr(520,7)§Ú­n¶K¨ì¤u§@ï¤W§Ú¥Î[a4].resize(520.7)=arr
¬O¦³¶K¤W¦ý¾ã­Ó¤u§@ï¨ä¥L°Ï°ì³£³Q²MªÅ¸§Ú¥u·Q­nrange(a4:g523)
ªº°Ï°ì¶K¤Warr()¨ä¥L°Ï°ìªº¤½¦¡¤£­n°Ê¨ì,¤£ª¾­n«ç°µ?
¥i¥H¦³°ª¤H«üÂI¤@¤U¶Ü?

¦^´_ 1# etpanda02

"¦³¤@­Ó¼Æ²Õarr(520,7)§Ú­n¶K¨ì¤u§@ï¤W§Ú¥Î[a4].resize(520.7)=arr"

    [a4].resize(520.7)=arr ¥´¿ù¤F¶Ü? "."  ","
    [a4].resize(520,7)=arr
     
¨Ñ°Ñ¦Ò

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD