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

°£¿ù

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2018-11-1 10:51 ½s¿è

offset , cells ¥i¾Ü¤@¥Î, ¦P®É¨Ï¥Î¦h¦¹¤@Á|!!
cells(1,0) = ¦V¥ª²¾1®æ ---   ·í³B¤_AÄæ, µo¥Í¿ù»~
cells(1,-1) = ¦V¥ª²¾2®æ --- ·í³B¤_BÄæ, µo¥Í¿ù»~

offset(0,0) ¬Û·í¤_ cells(1,1),   ¨ä°Ñ¼Æ®t1

¨ú³æ¤@Àx¦s®æ, ¤£¶·¦A¥Îresize

TOP

¦^´_ 7# faye59


³æ¿WCells(?,?), ¬O¥H¤u§@ªí¬°·Ç(¥HA1¬°°_©l,¦V¥k©Î¦V¤U°¾²¾), ©Ò¥H[­t¼Æ]©Î[0]¤£¥i¥Î,
Range("H8").cells(?, ?) , «h¥i¥HH8¬°¤¤¤ß, ¤W¤U¥ª¥k°¾²¾~~¥¿¼Æ/­t¼Æ/0¬Ò¥i¥Î, ¥u­n¤£¶W¥X¤u§@ªí½d³ò~~

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD