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

Public °ÝÃD

Public °ÝÃD

¬°¤°»ò¤£¯à¥Î?

AAA.JPG (32.79 KB)

AAA.JPG

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

­n©ñ¦bsub ***()ªº¤W¤è

TOP

¦^´_ 2# oobird


    ¨º»ò½Ð°Ý§Ú·Q­n  Public ÅܼÆMYW ­n¦pªG°µ?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥ÎPublic ©w¸q¥þ§½Åܼƭn§â©w¸q©ñ¦b³Ì¤W¤è¡I

TOP

public gsVal as string
sub aa()
gsVal="Hi Min"
end sub
­Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I                  
­Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-9-23 22:22 ½s¿è

©ú¥Õ¤F^^
ÁÂÁÂ2¦ì¤j¤j.

ÁÙ¦³1­Ó°ÝÃD¬O
¬°¤°»ò³o¼Ë·|¿ù?
Sheet1.Range(Cells(MYO, 1), Cells(MYO, 6)) = Sheet5.Range(Cells(MY1, 1), Cells(MY1, 6))
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

= Sheet5.Range(Cells(MY1, 1), Cells(MY1, 6)).value

TOP

¦^´_ 7# oobird


    2Ãä¥[¤Fvalue ³£¦³¿ù»~><
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥[¤£¥[value³£¬O¿ù¡C³o¬O­Ó³Ì®e©ö©¿µø©M¥Çªº¿ù»~¡G
Sheet1.Range(Sheet1.Cells(MYO, 1), Sheet1.Cells(MYO, 6)) = Sheet5.Range(Sheet5.Cells(MY1, 1), Sheet5.Cells(MY1, 6))

TOP

¨ä¥L¤H´N­ì½Ì¤F¡A¶Wª©ÁÙ­n¥Ç¡A¥u¦³¥s¥L¤T¤Ñ¤§¤ºÅé­«´î10Kg¡C

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD