+ Reply to Thread
Results 1 to 2 of 2

I need the code for hiding a column if a cell in that column has no date.

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    Oxfordshire
    MS-Off Ver
    Excel 2007
    Posts
    2

    I need the code for hiding a column if a cell in that column has no date.

    Hi

    I know this problem has been visited a few times but I cant seem to get the various solutions to work.

    I have an annual calendar showing only week commencing dates across the top of a table in row 5. the cells in row 5 contain the formulas to show the correct date for a particular year set in another cell.
    I need some code so if the cell d5 for example returns no date then the column D needs to be hidden.
    The row in question does contain more than 1 blank so D5 to BV5 is the range that any blank cell needs to have its own column hidden.
    Thanks in anticipation.

    Martyn

  2. #2
    Registered User
    Join Date
    01-11-2013
    Location
    Oxfordshire
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: I need the code for hiding a column if a cell in that column has no date.

    Here is a sample.
    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