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

(¤w¸Ñ¨M)¦Û°Ê¶ñº¡¥i¥H¦Û¤v»`´M¸ê®Æ¶q¶Ü?

(¤w¸Ñ¨M)¦Û°Ê¶ñº¡¥i¥H¦Û¤v»`´M¸ê®Æ¶q¶Ü?

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:16 ½s¿è

Selection.AutoFill Destination:=Range("S2:S8213")
¥i¥H³]©wÅý¥LÀH¸ê®Æ¦h¹è¦Û°Ê§PÂ_°Ï°ì¶Ü?
¥Ø«e§Ú³£¬O±NRange("S2:S8213")§ï¬°Range("S2:S20000")©ÎªÌ§ó¦h
¤§«á¦b§R°£²Ä¤@Äæ¸ê®Æ¬°ªÅ¥Õªº¸ê®Æ¹F¨ì§Ú­nªº¤è¦¡
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¦^´_ 1# freeffly


   °ò¥»¥\
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# freeffly


    ­º¥ý¡A³o­Ó°ÝÃDÀ³¸Ó¦b"Excelµ{¦¡°Ï"µo°Ý§a!
¨ä¦¸¡A¦^À³±zªº°ÝÃD¡A°²³]¥HR columnªº¸ê®Æ¶q¬°¨Ì¾Ú¥i¥H¼g¦¨
Selection.AutoFill Destination:=Range("S2:S" & Range("R65536").End(xlUp).Row)

TOP

¥»©«³Ì«á¥Ñ ¦Ñ®L ©ó 2010-7-15 15:22 ½s¿è

victorl²æ¿Ç¤l©ñ§¾
*****************************************************
1.ªÅ¥Õ¤u§@ªí>>D1Áä¤J1>>«öEnterÁä>>¿ïD1>>¶ñº¡¤U©Ô¦Ü²Ä100¦C

2.E1Áä¤J1>>>>¿ïE1:F1>>¶ñº¡ÂùÀ»

3.C1Áä¤J¥Ò>>«öEnterÁä>>¿ïC1>>¶ñº¡ÂùÀ»
*****************************************************
¸U¨ÆVBA,Á٬ƻòµ{¦¡°Ï,¦Û¤v¤£À´ÁÙ,­n»~¾É·s¤â

³o¬O°ò¥»¾Þ§@,¥u·|©ì¦²¤£À´±oÂùÀ»,±Ë²´NÁc,°ÝÃD¶V·d¶V½ÆÂø

[°ò¥»¥\]
http://forum.twbts.com/viewthread.php?tid=93

»{ÃѤu§@ªí
http://forum.twbts.com/viewthread.php?tid=707
********************************************************

freeffly:
°ÝÃD¥á¥X¨Ó,µM«á©ñ°²¥h,¤£¦^À³°ÝÃD,¤T¤Ñ«á¦A¦^¨Ó´zµª®×
³oºØ¤ßºA³Ì®t«l,½Ö¤í§A?

µ¹§A¦C¬°©Úµ´©¹¨Ó¤á,¤j®a³£¤£¦^À³§A°ÝÃD

TOP

¦^À³¦Ñ®Lª©¤j
ª`·N¼Ó¥Dªº´£°Ý"Selection.AutoFill Destination:=Range("S2:S8213")"³o¬O¤@¯ë¾Þ§@ªº´£°Ý¶Ü????
±Í¤H¤~²¨¾Ç²L¡AÁÙ±æ½Ñ¥ý¶i«ü±Ð¡C

TOP

¦^À³¦Ñ®Lª©¤j
ª`·N¼Ó¥Dªº´£°Ý"Selection.AutoFill Destination:=Range("S2:S8213")"³o¬O¤@¯ë¾Þ§@ªº´£°Ý¶Ü? ...
victorl µoªí©ó 2010-7-16 02:43

®L¦Ñ¤jªº·N«ä¬O»¡,¼Ó¥Dªº°ÝÃD¨Ï¥Î°ò¥»¥\¤Ò´N¥i¸Ñ¨M,¤£»Ý¥Î¨ìVBA,¤º«Øªº¥\¯à´N¥i¸Ñ¨M
¦Ó§Aªº¦^µª¬O´N¼Ó¥Dµo°Ýªº¤è¦V¥[¥H©µ¦ù,°ò¥»¤W¨â¦ìªº¦^µªÀ³¸Ó³£¥i¸Ñ¨M°ÝÃD
¤£½×¶Â¿ß¥Õ¿ß,¯à§ì¦Ñ¹«ªº´N¬O¦n¿ß!!
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

TOP

¹ï¤£°_
§Úªº½TÀ³¸Ó­n©ñ¨ìµ{¦¡°Ïµo°Ý
ÁÂÁ¤j¤jªº¦^À³
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD