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

¤u§@ªí¤º¦CªºÁôÂÃ

¤u§@ªí¤º¦CªºÁôÂÃ

¦U¦ì¦n
  workbook  ¤º¦³ sheet1 & sheet2   ¾Þ§@¦b  sheet2 ¶i¦æ
   SUB  hide()
      Rows("47:120").Select
   Selection.EntireRow.Hidden = True
­Y§Ú·Q¥ÎÅܼƨÓÁôÂÃÀ³¦p¦ó?½Ð«ü¾É  
sheet2 A5Àx¦s®æ¬°ÅܼÆ(¦³µ{¦¡¦b¤º)  [A5]+7  ¨äµ{¦¡¦p¦ó?
·íA5¬° 50®É«h Rows("57:120").Select
·íA5¬° 56®É«h Rows("63:120").Select

¦^´_ 1# jim
  1. Sub hide()
  2.   Rows([A5] + 7 & ":120").Hidden = True
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 2# register313
register313 ¤Ó§¹¬ü¤FÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD