+ Reply to Thread
Results 1 to 5 of 5

hide columns based on date

  1. #1
    Registered User
    Join Date
    06-28-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    25

    hide columns based on date

    Hi, on row 4 i have a list of column headers starting at F4 containing the weekending dates (friday). I wish to have a macro which would hide every column apart from the current week and the previous two weeks. I've lookied online and found little to help me with this.

    ---------- Post added at 08:57 AM ---------- Previous post was at 07:52 AM ----------

    anyone got any ideas?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,960

    Re: hide columns based on date

    Without a sample workbook I'm only guessing:
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    06-28-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: hide columns based on date

    Book1.xlsm

    Heres the sheet I'm using, couldn't quite get your code to work.

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,960

    Re: hide columns based on date

    This one will work if the worksheet only has columns tor Jan - Dec of one year only.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-28-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: hide columns based on date

    found another way around this. thanks alot anyway!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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