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

[µo°Ý] ½Ð°ÝRange¤º¦³Åܼƪº¼gªk

¦^´_ 10# homeman

³t«×À³¸Ó¤£¬O¦bRANGE©ÎCELLSªº¼gªk
¥i¯à¬O§A¦b¹Bºâ¨ä¦ì§}¦r¦ê»PÄæ¦C¸¹ªº¤èªk¥X²{®t²§
¤£§«±N±z´ú¸Õªºµ{¦¡¶K¤W¨Ó¬Ý¬Ý
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 11# Hsieh

sir , ©Î³\ªø¤[¥H¨Ó,¤@ª½¦³µÛ¿ù»~ªºÆ[©À, §Ú·|¸ÕµÛ±N¤@¤ä¤jªºµ{¦¡¥hÅçÃÒ, ¦pªG¹ï©ó³o­ÓijÃD¤´¦³¤£¦Pªº¬Ýªk, §Ú¦A§â sample ¥á¤W¨Ó,, ¦A³Â·Ð±z¨ó§U½T»{. Thanks
Homeman

TOP

¦^´_ 8# Hsieh

¤£¦n·N«ä§ÚÁÙ¬O¦³ÂIconfuse
1.  Range ÄÝ©Ê
¥i¥Î Range(arg) ¶Ç¦^¥Nªí³æ­ÓÀx¦s®æ©ÎÀx¦s®æ½d³òªº Range ª«¥ó¡A¨ä¤¤ arg ¬°½d³ò¦WºÙ(¦r¦ê«¬ºA)¡C
   

¥H¤U¨â¦æªí¥Üªº¬O¦P¼ËªºªF¦è
        Range("A1").Value = "A1"
        Range("A" & 1).Value = "A1"

Range¸Ì­±­n ¦r¦ê«¬ºA ªº½d³ò¦WºÙ¡A©Ò¥H("A1")¨S¦³°ÝÃD
¦ý¬O("A" & 1) ¤£¬O ¦r¦ê ¥[¤W ¼Æ­È ¨âºØ«¬ºAªº²V¦X¶Ü?
Á`ı±o³o¨âºØªí¥Üªk¨ã¦³¤£¦P«¬ºA...

TOP

¦^´_ 13# sweetkitty

¥u­n¥Î&³s±µ«á³£¦¨¤F¦r¦ê«¬ºA
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-2-1 19:38 ½s¿è

¦^´_ 13# sweetkitty

Range("A1")    =>   ª½±µ»¡©úA1 (¦r¦ê)
Range("A" & 1) =>  "A"³s±µ1(¦r¦ê³s±µ¼Æ¦r)(³oºâ¬O¦r¦ê)  => ¤]¬OA1(¦r¦ê)
¨âªÌ¬O¬Û¦Pªº,³£¬O«üA1Àx¦s®æ

Range("A" & A)  ­Y¥ý«ü©wÅܼÆA¤§­È=1    =>    "A"³s±µÅܼÆ(¦r¦ê³s±µÅܼÆ(ÅܼƤ§­È=1))(³oºâ¬O¦r¦ê)  => ¤]¬OA1(¦r¦ê)
Range(A & 1)    ­Y¥ý«ü©wÅܼÆA¤§­È="A"  =>                                                                          => ¤]¬OA1(¦r¦ê)
¼Æ¦r¥H¥~ªº¦r¤¸¥²¶·¨Ï¥ÎÂù¤Þ¸¹¼Ð¥Ü¡A§_«h·|³Q»{©w¬°ÅܼƦWºÙ

TOP

·PÁÂregister313 ¤j¤jªº¸É¥R»¡©ú!
²{¦b§Ú«D±`²M·¡ªº¤F¸Ñ¤F ^^

TOP

Range &  Cell ¤§¶¡ªº¤¬¬ÛÀ³¥Î

¯uªºÆZ¦hºØÂà´«ªº

§Úª¦¤å¦^¥h ¨S¦³·Q¨ì·í¦~´N¦³¤H°Ý¹L¤F  

¨ü±Ð¤F^^

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD