Results 1 to 1 of 1

VBA that hides columns based on dates to and from in selected cells

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2003
    Posts
    1

    Red face VBA that hides columns based on dates to and from in selected cells

    The spreadsheet attached Shows a start date and end date

    Along the right hand side you have WEEK COMMENCING DATES in each week number

    If i put 31/03/2012 in start date and 07/04/2012 in the end date cells, i would like to hide the rest of the weeks and just have weeks 1 and 2?

    This will then need to work for the rest of the sheet, i.e. If i put 07/04/2012 to 28/04/2012 i would expect only to see weeks 2 to 5.

    Not the best at VBA and was wondering whether anyone can help me with this!!

    Cheers

    Sheet attached!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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