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

[µo°Ý] Ãö©ó´M§ä"³Ì«á¤@¦C(¦æ)"

[µo°Ý] Ãö©ó´M§ä"³Ì«á¤@¦C(¦æ)"

¥»©«³Ì«á¥Ñ thps51134 ©ó 2011-11-3 17:13 ½s¿è

½Ð±Ð
".UsedRange.SpecialCells(xlLastCell).Row"ªº·N¸q
¥H¤Î, «ç¼Ë¥i¥H°µ¨ì§ó°Ê³o¼Ë§ì¨ú¨ìªºfinal row (col.) ?

======
¨Ï¥Î¦¹¤èªk§ì¨ú³Ì«á¤@¦C

    RowEnd = ActiveSheet.UsedRange.SpecialCells(xlLastCell).Row

¾ã­ÓÀˬd¹L«á
¸ê®Æ¯uªº¥u¦³¨ì±Nªñ 300µ§
¦ý¬ORowEnd«o¤@ª½Åã¥Ü¬° 559

¦³Å¥¹L³o­Ó¤èªk¨ä¹ê¬O§ì"³Q°µ¹L°Ê§@ªº®æ¤l"
©ó¬O¤@¸ô©Ô¨ì²Ä65532¦C (¥u¬O¿ï¨ú)«á, Àx¦s¦A¶}±Ò
¨Ì¬OÅã¥Ü³Ì«á¤@¦C¬°²Ä559¦C

=====

ÁÂÁÂ!

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-11-3 20:24 ½s¿è

¦^´_ 1# thps51134
UsedRange ÄÝ©Ê  ¶Ç¦^ Range ª«¥ó¡A¦¹ª«¥ó¥Nªí«ü©w¤u§@ªí¤¤ªº¤w¥Î½d³ò¡C°ßŪ¡C
SpecialCells(  °Ñ¼Æ  ) ¤èªk ¶Ç¦^ Range ª«¥ó¡A¦¹ª«¥ó¥Nªí»P«ü©w«¬ºA¤Î­È¬Û²Å¦Xªº©Ò¦³Àx¦s®æ¡CRange ª«¥ó¡C
°Ñ¼Æ : xlCellTypeLastCell¡C¤w¥Î½d³òªº³Ì«á¤@­ÓÀx¦s®æ   
UsedRange.SpecialCells(xlLastCell).Row ->¶Ç¦^¤u§@ªí¤¤ªº¤w¥Î½d³ò¤¤«ü©w«¬ºA¤Î­È¬Û²Å¦Xªº(³Ì«á¤@­ÓÀx¦s®æ)©Ò¦³Àx¦s®æªº¦C¸¹

©ó¬O¤@¸ô©Ô¨ì²Ä65532¦C (¥u¬O¿ï¨ú)«á, Àx¦s¦A¶}±Ò
¨Ì¬OÅã¥Ü³Ì«á¤@¦C¬°²Ä559¦C
  
¦p¦b65532¦C ¦³¿é¤J¸ê®Æ ·|¶Ç¦^ 65532 ªº

TOP

¾ã­ÓÀˬd¹L«á
¸ê®Æ¯uªº¥u¦³¨ì±Nªñ 300µ§
¦ý¬ORowEnd«o¤@ª½Åã¥Ü¬° 559
thps51134 µoªí©ó 2011-11-3 17:11

§Ú²q´ú¥i¯à¬O²Ä 559 ¦C(©Î³\¨ä¥LÀx¦s®æ¤]¦³)¦³ªÅ¥Õ¦r³y¦¨,
­YªG¯u¦p¦¹¨º»ò§A»Ý­n°µªº¥u¦³¤@¥ó¨Æ :
1. §ä¨ì(¦³¸ê®Æ)ªº³Ì©³¤Uªº¤@µ§¸ê®Æ
2. ±q¦¹µ§¸ê®Æªº¤U¤@¦C¶}©l Mark ¾ã¦C
3. «ö¦í·Æ¹«¥ªÁ䤣©ñ¤@ª½©ì¦²¨ì²Ä 600 ¦C
4. ±N Mark ªº°Ï°ì¥þ³¡§R°£
³Ì«á¦A¸Õ¬Ý¬Ý¬O§_µ²ªGÅÜ¥¿½T¤F.

³o¤èªk§Ú³q±`³£¥Î¦b¹wÄý¤å¥ó®Éµo²{¦³¦h¾lªºªÅ¥Õ­¶®É.

TOP

°Ê§@«üªº¬O"¹ê»Ú¡A¦³¦¨®Ä"ªº°Ê§@¡A¤£¥]¬A¿ï¨ú¡C

¦b²Ä600¦C¥ô¤@Àx¦s®æ¿é¤J¸ê®Æ¡AµM«á¿ï¥¦¨Ã²M°£¤º®e¡C
ActiveSheet.UsedRange.SpecialCells(xlLastCell).Row ·|¬O 600¡C

¤Z¨«¹L¥²¯d¤U²ª¸ñ¡C

TOP

¥»©«³Ì«á¥Ñ thps51134 ©ó 2011-11-8 17:56 ½s¿è

·PÁ¦U¦ìªº¦^ÂÐ¥H¤Î´À§Ú°µ¤FÆ[©À¼á²M

GBKEE¤jªº¸ÑÄÀ¸ÔºÉ¨ì¥O¤H·P°Ê

·PÁ luhpro¤jªº«Øij,
¤§«e¥u¦³°µ¹L"delete"¦Ó¨S¦³¸Õ¹L"§R°£"
¤jµ§¤@§R, °ÝÃD¸Ñ¨M!

ÁÂÁ e123chenÀ°§ÚÂç²M¤°»ò¬O§Ú¬d¨ìªº¸ê®Æ©Ò´y­zªº"°Ê§@"
:)

TOP

§Ú¤§«e¤@ª½©È»¡·|¦³¤¤¶¡¦³ªÅ®æ²£¥Íªº±¡ªp¡A¥Î"xlLastCell"¨S¿ìªk§ä¨ì©Ò¦³ªºÄæ¦ì
¤§«á¦³¤H±Ð§Ú¥Îcells(65536,j).end(xlup)
µ²ªG¦n¦h¤F¡A¤£ª¾¹D³o¼Ë¬O§_»P±z©Ò²z¸Ñªº¬Û¦P

TOP

¥»©«³Ì«á¥Ñ thps51134 ©ó 2011-11-21 10:34 ½s¿è

¦^´_ 6# smooth131


    ´N§Ú¥Ø«e¨Ï¥Îªºª¬ªp...ªÅ®æ¬O¤£¼vÅT"xlLastCell"ªºµ²ªG°Õ^^"

¡@³o¦¸¹J¨ìªº°ÝÃD¬O
    "¹ê»Ú¤W¨S¦³¸ê®Æ«o§ì¨ì»¡¦³¸ê®Æ" ¤£¬O "¹ê»Ú¤W¦³¸ê®Æ«o§ì»¡¨º¦C¨S¸ê®Æ"
¡@·PÁ±zªº¤À¨É^^

TOP

¦³¤@­Ó²{¶H¥i¥H¸ÑÄÀ"¹ê»Ú¤W¨S¦³¸ê®Æ«o§ì¨ì»¡¦³¸ê®Æ"¡A
¨º´N¬O"¦³ªÅ¥ÕÀx¦s®æ³Q³]©w¤F®æ¦¡"¡A
¦]¦¹·|±N¦¹Àx¦s®æ¯Ç¤JUsedRange¤¤¡C
©Ò¥H§A³æ¯Â¥Îdelete¬O¨S¦³¥Îªº¡A
¥²¶·²M°£Àx¦s®æ®æ¦¡©Î¥þ³¡¤~¦³¸Ñ¡C

TOP

UsedRange.SpecialCells(xlLastCell).Row
À´¤F!

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD