+ Reply to Thread
Results 1 to 4 of 4

Please help. Hide rows after specific date

  1. #1
    Registered User
    Join Date
    11-04-2011
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    20

    Question Please help. Hide rows after specific date

    I want to hide 4 rows after 22nd day of every month on my worksheet. The date is on the C column.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Please help. Hide rows after specific date

    the 1st day row?

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Please help. Hide rows after specific date

    As an example

    Right Click on your sheet name at the bottom of excel and select view code.

    Paste this code into the module that opens and then close it.

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  4. #4
    Registered User
    Join Date
    11-04-2011
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Please help. Hide rows after specific date

    Start date varies, but end date is always 21st of every month. I want to hide rows after 21st about 4-5 rows only. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. code to hide specific rows
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2016, 11:05 AM
  2. VBA to hide specific rows?
    By lazyengineer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2015, 04:06 PM
  3. [SOLVED] Hide specific Rows in Sheet1 + hide 5 more in Sheet2
    By bluesurger in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-02-2014, 07:19 AM
  4. [SOLVED] Hide rows only on specific worksheets
    By MissaLissa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-14-2014, 01:15 PM
  5. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM
  6. Hide specific Rows
    By Jakes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2012, 05:22 AM
  7. [SOLVED] Hide rows with 0 value in specific ranges
    By persais in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2012, 02:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1