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

[µo°Ý] ªÅ¥ÕÄæ¦ì¤£¦C¦L°ÝÃD½Ð±Ð

[µo°Ý] ªÅ¥ÕÄæ¦ì¤£¦C¦L°ÝÃD½Ð±Ð

¤p§Ì°ò¥»¸ê®Æ±Nªñ2­¶(Á|¨Ò)¡A¦]²Ä53-85¦CÄæ¦ì¬O­n«O¯d¤£¥i§R°£ªº¡A¬O§_¦b¦C¦L®É¡A¥i¥H§Q¥Î¥¨¶°¥\¯à¦Û°Ê±N³Ì«á²Ä86¦CÄæ¦ì©¹¤W²¾¡A´î¤Ö¦C¦LªÅ¶¡¡C¤]´N¬O»¡ªÅ¥ÕÄæ¦ì¤£¦C¦L¥X¨Ó¡A½Ð¦U¦ìÀ°¦£!!

¦C¦L°ÝÃD.rar (3.79 KB)

¦^´_ 4# Hsieh

·PÁÂHsiehª©¥D
¤p§Ì¤S¼W¥[¹wÄý¦C¦L¥\¯à·f°t
ActiveWindow.SelectedSheets.PrintPreview

TOP

¦^´_ 3# honching99
  1. Sub ÁôÂÃ()
  2. Range("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
  3. End Sub
  4. Sub ´_­ì()
  5. Cells.EntireRow.Hidden = False
  6. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# binargoo


    ·PÁÂbinargoo¦^À³¡A¤£¹L¦]¸ê®ÆÆZ¦h¡A¨C¦¸­«½ÆÁôÂäӳ·СA©Ò¥H¤~«ä¦Ò¥i§_¥Î¥¨¶°¤è¦¡¨Ó²¤Æ!!!

TOP

¥»©«³Ì«á¥Ñ binargoo ©ó 2011-10-1 16:22 ½s¿è

¦^´_ 1# honching99

¼Ð°O53~85\¥kÁäÁôÂáA¦C¦L¤§«á¦A«ì´_²³æ¤£½ÆÂø¡C
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD