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

[µo°Ý] ¨Ï¥ÎRows(Range() & Range())¨S¦³¥X²{¿ù»~,¦ýµLªk¥¿±`¹B§@

[µo°Ý] ¨Ï¥ÎRows(Range() & Range())¨S¦³¥X²{¿ù»~,¦ýµLªk¥¿±`¹B§@

¦pÃD¡A¼g¥X¨Óªºµ{¦¡¨S¦³¥X²{bugªºÄµ°T¡A¦ý¬O«oµLªk¥¿±`¤ÏÀ³

µy·L»¡©ú¤@¤U³o­Óªí®æªº·N¸q»P·Q­n°µ¨ìªº¥\¯à

°ò¥»¤W³o¬O¤@­Ó¯Zªí¡A¤@­Ócolumn¬O¤@­Ó¤Hªº¦W¡A¦Órow·|ÀHµÛ·í¤é·~°Èªº¦h¹è¦Ó¼W´î(´¡¤J/§R°£row)¡C¨C±ß­nµo¥¬¹j¤Ñªº¯Zªí¡A¦ý¦]¬°¾ã­Óªí®æ¤Ó¤j¤£¦n¦b¤â¾÷¤W¾\Ū¡A©Ò¥H·|§â°£¤F©ú¤Ñ¥H¥~ªºrow³£ÁôÂð_¨Ó¤è«K¾\Ū¡C

·Q­n°µ¨ìªº¥\¯à¬O¡G¤@ÁäÁôÂäW­zrow/¤@Áä¨ú®ø¥þªí®æÁôÂÃ(µo¥¬§¹²¦«á«ì´_­ìª¬)¡Aªì¾Çvba¤@©P¦h¡A¥Ø«e¥u·Q¨ì¥Hif else°µ¼É¤O¯}¸Ñ¡A­n¬O¦U¦ì¦³§ó§Ö§ó²¼äªº¼gªkªº¸ÜÅwªï§i¶D§Ú¡I

¥H¥Ø«e§Úªº¼gªk¡A­nÅçÃÒ¦³¨S¦³¹B§@¥¿½T¦³¤T­ÓÃä¬É¨Ò¤l¥i¥H°µtest¡G
1.·í¤µ¤Ñ¬O·í¤ë¥÷³Ì«á¤@¤Ñ: ¨Ò:¤µ¤Ñ2/28, ·ísheet°±¯d¦b2¤ë®É,¼u¥X°T®§¡¨½Ð¦Ü¹j¤ë¥÷¯Zªí¡¨,·ísheet¦b3¤ë®É¡A¥u«O¯d3/1ªºrow
2.·í¤µ¤Ñ¬O·í¤ë¥÷²Ä¤@¤Ñ ¨Ò:¤µ¤Ñ2/1,¥u«O¯d2/2
3.·í¤µ¤Ñ¬O·í¤ë¥÷¤¤¶¡ªº¤é¤l(°£¤F¤W­z) ¨Ò:¤µ¤Ñ2/25,¥u«O¯d2/26

¥H¤U¬O§Ú°w¹ï3.¼gªº¤@¬q½X¡A¨S¦³¥X²{bug error¡A¦ý«oµLªk¥¿±`ªºÁôÂÃ2/1~2/25©M2/27~2/28
ªí®æÁÙ·|¦Û°Ê¼u¨ì«D±`¤U­±ªº¦a¤è(A207203¤§Ãþªº)

    Else 'the other days
   
    Rows(Range("Z221") & Range("Z214")).Select 'select first day to today
    Rows(Range("Z226") & Range("Z218")).Select 'select last day to 2tmr
    Selection.EntireRow.Hidden = True
   
    Columns("C:U").Select
    Selection.EntireColumn.Hidden = True
   
¥H¤Wªºµ{§Ç·d¿ù­þ­Ó¦a¤è¤F¶Ü?

¥H¤Uºô§}¥i¥H¤U¸üexcel­ìÀÉ
https://drive.google.com/open?id=1Q_AGzadFVKYYkWKc3_oOOnXptM0tg0H3
(¦³¨Ç³z¹Lexcel­pºâ¥X¨Óªºrow­È©ñ¦bV212ªþªñ¡A¥i¥H°Ñ¦Ò¤@¤U)

³Â·Ð¦U¦ì´£ÂI¤@¤U¡A¤Q¤À·PÁ¡C
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

Rows(Range("Z221") & ":" & Range("Z214")).Select

TOP

¦^´_ 2# ­ã´£³¡ªL

¤Ó·PÁ¤F!! ­ì¨Ó°ÝÃD¬O¥X¦b³o­Ó¦a¤è
©Ò¦³ªº¥\¯à³£·Ó±`¹B§@¤F
ÁÂÁ´£ÂI
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD