+ Reply to Thread
Results 1 to 1 of 1

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

Hybrid 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

+ Reply to Thread

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