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

[µo°Ý] »yªk°ÝÃD?

[µo°Ý] »yªk°ÝÃD?

§A¦n
¤w¥ÎGoogle§ä¹L,¨S¦³§ä¨ìµª®×
·Q½Ð°Ý¬°¤°»òActiveSheet ¿é¤J.«á¨S¦³¤U©Ô¦¡¥i¥H¿ï,Selection ¤]¬O
¦ý¬O ActiveWorkbook ·|¦³?(Ex. ActiveWorkbook.PrintPreview)
ActiveSheet.­n¦Û¦æ¿é¤JPrintPreview,«Ü³Â·Ð·|±`¦³­Ó­^¤å³æ¦r¿é¤J¿ù»~,¦U¦ì¬O¦p¦ó§JªA³o­Ó°ÝÃD?
·s¤â¤W¸ô µê¤ß½Ð±Ð

Range(¡§A3¡¨).CurrentRegion.Rows.Count
ActiveSheet.ListObjects(1).listRows.Count

¤W­±µ{¦¡2­Óµ{¦¡³£¥i¥H¨D¨ì¸ê®Æªºµ§¼Æ
,¬°¦óÁÙ­n¥ÎListObjects, ListObjectªºÄݩʬ°¤°»ò³£­n¦Û¤vKey(¨Ò¦p: .InsertRowRange), CurrentRegion¥u­nkey ¡§.¡¨ ´N¥i¿ï°Ê§@&ÄÝ©Ê

¬O¦]¬°±Ä¥ÎListObjects ¦³¤°»òÀuÂI©O?½Ð¦U¦ì¾ÇªøÀ°§Ú¸Ñµª¤@¤U
·s¤â¤W¸ô µê¤ß½Ð±Ð

TOP

¦^´_ 2# fu1835t


   
¥¼©R¦W.JPG
2014-7-28 15:48


¸Õ¸Õ Sheet1 ¬Ý¬Ý(³o±M®×ªºª«¥ó¦¨­û)
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 3# GBKEE

GBKEE ÁÂÁ§Aªº«ü¾É
Sheet1. ¯uªº¥i¥Hª½±µ¿ï ¤èªk&ÄÝ©Ê   (ps. ¦Û°Ê¦C¥X¦¨­ûªº³]©w§Ú¤w¸g¤Ä¿ï¹L¤F)

Sheet1.ListObjects(1).InsertRowRange  
Sheet1.PrintPreview  >>³£¤£¥Î¿é¤Jª½±µ¥Î¿ïªº

¦Ü©óSelection or ActiveSheet >>keyin ¡§.¡¨¨S¦³¶]¥X¿ï³æ¥i¿ï,§Ú»{¬°Selection or ActiveSheet ³£¬OÄÝ©Ê«Dª«¥ó,©Ò¥Hkeyin ¡§.¡¨¨S¦³¶]¥X¿ï³æ¥i¿ï
¥H«e§Ú³£»{¬°
WorkSheet("Sheet1").select     
Selection À³¸Ó¬Oª«¥ó(¦]¬°§Ú¿ï¨ì¤FSheet1,¨ä¹êSelectionÁÙ¬OÄÝ©Ê>>¦pªG¦³¿ù½ÐÀ°¦£ªÈ¥¿
·s¤â¤W¸ô µê¤ß½Ð±Ð

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD