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

[µo°Ý] ½Ð±Ðª«¥óÅܼƪº»yªkset»Pwith-end with

set rng = Sheets("1").Range(Sheets("1").[c10], Sheets("1").[m83].End(3))
³o¼Ë¬O§ârng©w¸q¬°rangeª«¥ó(¹ï¶H)
»P«e­±©w¸q¦¨°}¦C¦b®Ä¯à¤W¤£¯à¦P¤é¦Ó»y¡I

TOP

³o¼Ërng¬O¤@­Ó2ºû°}¦C¡A¨S¦³Àx¦s®æ¨ä¥L¸ê°T¡A¥u¦³­È¡C¦s¦b°O¾ÐÅ餤¡Aµ{¦¡µ²§ô«á§Y®ø¥¢¡C

TOP

1.¥ý¤F¸Ñwith
¨Ï¥Îwith¥i´î¤Ö¹ïÀx¦s®æªºÀWÁc¦s¨ú¡C§ó¥i¥HÁYµuµ{¦¡½X¡A¥H¦¹¨Ò¨Ï¥Îwith«á
­ì¥»rng = Sheets("1").Range(Sheets("1").[c10], Sheets("1").[m83].End(3))
´N²¤Æ¦¨rng = .Range(.[c10], .[m83].End(3))
2.«e­±»¡¤F¬O§â³o­Ó½d³òªº¸ê®Æ¥H¤Gºû°}¦C¦s©ñ¦b°O¾ÐÅ餺¡A¤£¦A¬OÀx¦s®æ¤F¡A¦Ó¬O¯Â¯Üªº¸ê®Æ±Æ¦C¡CÄÝVariant«¬ºA¡A¦]exceÅܼÆl¹w³]­È¬OVariant¡A©Ò¥H¤£¥Î¼g¥X¨Ó¡C

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD