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

°½Ãi

°½Ãi

§Ú¦³´X­Ó°½ÃiªºÂI¤l
¥Î0,1¨Ó¥N´Àfalse, true ¨Ò¦p Application.ScreenUpdating = False, °½Ãi¼g¦¨ Application.ScreenUpdating = 0
¥Î1,2,3,4¨Ó¥N´À xlleft, xlright, xlup, xldown ¨Ò¦p [a65536].end(xlup).row, °½Ãi¼g¦¨ [a65536].end(xlup).row
¥Î1,2¨Ó¥N´À¹ê½uxlContinuous©Mµê½uxlDot ¨Ò¦p Selection.Borders.LineStyle = xlContinuous, °½Ãi¼g¦¨ Selection.Borders.LineStyle =1

³o­Ó²ßºD¤£¦n, ·|³y¦¨µ{¦¡½Xªº¥iŪ©Ê­°§C, ¥H«á¤£¦nºûÅ@

´N¹³¦³¨Ç¤H³ßÅw¥Î a~z ·íÅܼÆ, ¹L¤@¬q®É¶¡¦A¥h¬Ý, ²ª½¬O¤Ñ®Ñ

TOP

³o¬O«ÜÁV¿|ªº¼gªk
°£¤F True, False

TOP

§Ú¦³´X­Ó°½ÃiªºÂI¤l
¥Î0,1¨Ó¥N´Àfalse, true ¨Ò¦p Application.ScreenUpdating = False, °½Ãi¼g¦¨ Applica ...
ikboy µoªí©ó 2015-8-24 22:42


®M¥y§Ú¬Y¦ì®v³Å©Ò»¡ªº
¾A·íªº°½Ãi¼W¶i®Ä²v..
¹L«×ªº°½Ãi·|¾D¤ÑÄþ...


«Ü©úÅ㪺...
§A³oºØºâ¬O¹L«×ªº°½Ãi..
´Nºâ§A²{¦b¼g±o§A¬Ý±oÀ´
¦pªG¤£°Ê¨º­Óµ{¦¡ ¤@­Ó¬P´Á «á§A¦A¥h¬Ý «OÃÒ§A­nªá§ó¦h®É¶¡²z¸Ñ...

¬Û«H§Ú §Ú¦³ºGµhªº¸gÅç¹L...

±q¨º¤§«á §Ú¥u­n·Q°½Ãi
§Ú³£·|¦h¼g³Æµù....
¦ý... ³q±`¥u¦³§Ú¬Ý±oÀ´³Æµù¦b¼gÔ£....
²¦³º¨º¬OÄÝ©ó§Úªº¼gªk  ¼K¼K

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD