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

[µo°Ý] ¦p¦ó«ü©w¿ï¨úªº°Ï°ì

¦^´_  PJChen
¥¦¤£¬O¥²¶·ªº  
§AªºªþÀɻݦA»¡©ú¤@¤U ¹ê¦b¬O¬Ý¤£À´ »P  4# §Ú¦³¤@¥÷excel¡A¦ý¬O§Ú¶·­n¹ï¦P ...
GBKEE µoªí©ó 2012-1-19 07:28


ªþÀɪº¥Ø¼Ð¬O­n§â¡uA1¡ãA100¡v©î¦¨¡uA1¡ãA50¡v+¡uC1¡ãC50¡v¡A¨Ã¥B¬O¥æ¿ùªº¡I¨Ò¡GA1¡ã10=1¡ã10¡AC1¡ãC10=11¡ã20

©Ò¥H¡A"¦P¼Ëªº¤j¤pªº°Ï¶ô"«üªº¬O10­Ó³æ¦ì¡A"°µ¦P¼Ëªº°Ê§@"«üªº¬O§â¥¦±qSHEET1¶K¨ìSHEET2¡C
ªì¾ÇVBA¥E¨ìtwbts

TOP

¦^´_ 7# register313

½Ð°Ý¡A¦pªG§Ú­n¿ïªº½d³ò¤£¬O¥u¦³A¡A¦Ó¬OABC¤T¦æªº¸Ü¡A¨ºCELLS­n«ç»ò¥h©w¸q¡H¡H
ªì¾ÇVBA¥E¨ìtwbts

TOP

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

¦^´_ 12# play9091

­ì¨Ó:
AÄæ ==> AÄæ,CÄæ

«á¨Ó:
AÄæ, BÄæ,CÄæ ==> ???

¬O³o¼Ë¶Ü?
½d¨Ò.rar (10.4 KB)

TOP

¦^´_ 13# register313


­è­è·Q¤F¤@¤U¡A·Q¨ì¸Ñ¨Mªº¤èªk¤F¡K¡KÁÂÁ±zªºÀ°¦£¡I
ªì¾ÇVBA¥E¨ìtwbts

TOP

¬O³o¼Ë¶Ü¡H

Dim MyRan As Range
For i = 3 To 15
Set MyRan = Range(Cells(i, 1), Cells(i + 6, 4))
     MyRan.Select   
Next i

TOP

¬Ý¬Ý¤j¤j­Ìªº°Q½×¦h¤Ö¤]¾Ç¤@ÂIÁÂÁÂ
ELIOT JENG

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD