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

[µo°Ý] ½Ð±ÐÃö©ó¦X¨Ö¦C¦L°ÝÃD

¦^´_ 8# GBKEE

­Y¨ÌWordÀɸɻôExcelÄæ¦ì,°õ¦æ«á¦bWord¤¤¥u·|¥X²{[©m¦W]¤Î[¾Ç¸¹]¸ê®Æ,¨ä¾l¸ê®Æ³£¥¼Åã¥Ü
¤£ª¾¤°»ò­ì¦]?

991011-1.zip (7.09 KB)

°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 9# oobird

ÁÂÁÂ[oobird]ª©¥D
±q¨S³o¼Ë¥Î¹L,Àò¯q¨}¦h!
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 10# chiahuo

§Ú¸Õ¹L¦n¹³¤]·|º|¸ê®Æ
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 11# °¶ÔÐ
­×§ï    Set Rng = .WORKBOOKS(1).SHEETS(1).Range(First).End(2)
¦¨¦p¤U Set Rng = .WORKBOOKS(1).SHEETS(1).Range("IV2").End(1)

TOP

¦^´_ 14# GBKEE

ÁÂÁÂ[GBKEE]ª©¥D,¥i¥H¤F
³o¦æ¬O¦b©w¸q½d³ò,¥i¬°¦ó¬O Range("IV2").End(1)
¥i§_»¡©ú¤@¤U·N«ä,ÁÂÁÂ!
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

End(1)
=End(xlToLeft)

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2010-10-13 21:23 ½s¿è

¦^´_ 15# °¶ÔÐ
Set Rng = .WORKBOOKS(1).SHEETS(1).Range(First).End(2)  ->.End(2) ©¹¥k¨ì³Ì«á¤@­Ó¸ê®Æªº¦ì¸m.­ì¥»Àɮצ]¤¤¶¡¹J¨ìªÅ¥Õ·|¦bªÅ¥Õ«e°±¤î,©Ò¥H§ï¦¨±qÀɮתº³Ì«á¤@Äæ(2003ª© - IV)  
Set Rng = .WORKBOOKS(1).SHEETS(1).Range("IV2").End(1) -> End(1)  ©¹¥ª¹J¨ì²Ä¤@¦³¸ê®Æªº¦ì¸m
  
Set Rng = Rng.End(4)   ->End(4) -> End(4)  ©¹¤U¨ì³Ì«á¤@­Ó¸ê®Æªº¦ì¸m
Set Rng = .WORKBOOKS(1).SHEETS(1).Range(First, Rng)     '¨ú±o¸ê®Æ

TOP

¥»©«³Ì«á¥Ñ chiahuo ©ó 2010-10-14 10:50 ½s¿è

¦^´_ 13# °¶ÔÐ

³o­Ó¬O§Ú´ú¸ÕªºÀɮסA®æ¦¡¬O¾îªº
12¤H¨CÄæ¸ê®Æ³£¥i¥H¡A°Ñ¦Ò¬Ý¬Ý
EXCELÀɬO¦³³Ì¦­ªº®æ¦¡

991014.zip (9.81 KB)

¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

¦^´_ 16# oobird
ÁÂÁÂ[oobird]ª©¥Dªº¸Ñ»¡

¦^´_ 17# GBKEE    
ÁÂÁÂ[GBKEE]ª©¥D¸Ô²Óªº¸Ñ»¡,¤w©ú¥ÕÅo!
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 19# °¶ÔÐ


    ½Ð°Ý°¶ÔЪ©¥D
¦b¸Õ§@Àɮ׫á¦pªGWORD±Æª©©MEXCELºÝ¤@¼Ë«h¦X¨Ö¦C¦L·|¤ñ¸û²³æ
¥i¥H½Ð°Ý³Ì«á¨º­Ó"°ê¤¤¥Í"ªºµª®×..«ç»ò°µ¥X¨Óªº..(¦Ñ®vªº¼Ð·Çµª®×¬O¤°»ò??)ÁÂÁ±z.... ^ ^....






¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD