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

[µo°Ý] ²¾°Ê¨ì³Ì«á¤@µ§¸ê®Æ

[µo°Ý] ²¾°Ê¨ì³Ì«á¤@µ§¸ê®Æ

'²¾°Ê¦Ü¸ê®Æ³Ì«á¤@µ§
    Range("C2").Select
    Selection.End(xlDown).Select

·íCÄæ¨ä¤¤¤@¦CµL¸ê®Æ®É«h¶]¤£¨ì³Ì«á¤@µ§
¸ê®Æ¤@¦@¦³ABCDE¡A¦pªGABCDE³£¦³¾÷·|µL¸ê®Æ
¬O§_ÁÙ¦³¨ä¥L¤èªk¥i¥H§PÂ_«á²¾°Ê¨ì³Ì«á¤@µ§?

¦^´_ 1# av8d


    Range("A65536").End(xlUp).Select
¦pªG§A¦³¦bª¦¤åÀ³¸Ó·|«Ü®e©ö§ä¨ì³á~

TOP

¥»©«³Ì«á¥Ñ av8d ©ó 2012-7-12 09:30 ½s¿è

¦^´_ 2# dafa


¤j¤jÁÂÁÂ~
¦pªG¬O­n±q¸ê®ÆªíA¥ý²¾°Ê¨ì¸ê®ÆªíB¦A²¾°Ê¨ì³Ì«á¤@µ§¬O§_¬°
Sheets("B").Select
Range("A65536").End(xlUp).Select

¦]¬°·|¥X²{Class Range ªº Select ¤èªk¥¢±Ñ

¦ý¬O
Sheets("B").Select
ActiveSheet.Range("A65536").End(xlUp).Select

«h¥i¥H¤F~ÁÂÁ¤j¤j!

TOP



¦^´_ 3# av8d
Sheets("B").Select
Range("A65536").End(xlUp).Select  ¦]¬°·|¥X²{
Class Range ªº Select ¤èªk¥¢±Ñ
³o¬Oµ{¦¡½X¦b Sheetª«¥ó¼Ò²Õ(¤£¬O¤u§@ªí(B) ) ©Ò­P

¦]Sheets("B").Select  ±N§@¥Î¤¤ªºÂà¨ì¤u§@ªí(B)  
©Ò¥H Range("A65536").End(xlUp).Select ¬O¦b¦¹Sheetª«¥ó¼Ò²Õ(¤£¬O¤u§@ªí(B) ªº¤u§@ªí¤W)°µSelect  
Range  «e­±¨S¦³«ü©w¤u§@ªí ¬O¬°Sheetª«¥ó¼Ò²Õ(¤£¬O¤u§@ªí(B) ªº¤u§@ªíªº Range          ´N·|¦³¿ù»~

³o¬qµ{¦¡½X¦p¦b ¤@¯ë¼Ò²Õ ©Î ThisWorkbook¼Ò²Õ  ´N¤£·|¦³¿ù»~¤F

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD