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

½Ð°Ý¤@¦æµ{¦¡½X¥i¥H¿é¤J¦h­Ó¬Û³sªºÀx¦s®æ¸ê®Æ¶Ü?

½Ð°Ý¤@¦æµ{¦¡½X¥i¥H¿é¤J¦h­Ó¬Û³sªºÀx¦s®æ¸ê®Æ¶Ü?

¨Ò¦p
µ{¦¡½X­ì¬°¤T¦æ
cells(1,1)=99
cells(1,2)=ÀH¾÷0~100¾ã¼Æ
cells(1,3)=cells(1,1)+cells(1,2)

½Ð°Ý¥i¥H§âµ{¦¡½X¿@ÁY¦¨1¦æ¶Ü?

ÁÂÁÂ

cells(1,1)=99: cells(1,2)=ÀH¾÷0~100¾ã¼Æ: cells(1,3)=cells(1,1)+cells(1,2)

TOP

©êºp ¨S¦³»¡²M·¡
¤£¬O¥u¦³³æ¯Âªºµ{¦¡½XÅܦ¨¤@¦æ
¬O¤T¦æµ{¸Õ½X¤£·|¦P®É°õ¦æ¡A¦Ó¬O³v¦æ°õ¦æ
¦³¯à°÷Åý³o¤T¦æµ{¦¡½X¦P®É°õ¦æªº»yªk¶Ü?
©Î¬O½d³ò¯x°}?­n«ç»ò¼g©O?
ÁÂÁÂ

TOP

¦^´_ 3# jazzcarr


¨º¼Ë°µ¥Øªº­n·F³Â?

TOP

¥»©«³Ì«á¥Ñ jazzcarr ©ó 2018-3-2 13:47 ½s¿è

¦]¬°¨C¬í­n°õ¦æ¨â¦¸ ¦n¹³«Ü¦Y¸ê·½
¤@¦¸¶]§¹¬O§_·|¤ñ¸û¬Ù¸ê·½?

©Î¬O¥Îrange§ï¼g¿ì±o¨ì¶Ü¡H

TOP

¥»©«³Ì«á¥Ñ jackyq ©ó 2018-3-2 14:00 ½s¿è

A1 = 99
A2= ÀH¾÷0~100¾ã¼Æ
A3 = A1 + A2

Cells(1, 1).Resize(, 3) = Array(A1, A2, A3)

TOP

¤Ó´Î¤F ¤j·P®¦
¦ý¤S¹J¨ì¤F¤U¦C°ÝÃD
Àµ½Ð¸Ñ´b

http://forum.twbts.com/thread-20581-1-1.html

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD