+ Reply to Thread
Results 1 to 2 of 2

Hide all rows where a range of cells are blank

  1. #1
    Registered User
    Join Date
    06-02-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Hide all rows where a range of cells are blank

    I'm looking to hide all rows in my spreadsheet where a range of cells within that row are blank. The criteria must be that 5 cells in that row must be blank in order to hide that row.

    I've looked at the following topic which has been solved but having trouble replicating for my needs:

    http://www.excelforum.com/excel-prog...are-blank.html

    The range of cells is from I > M that must be blank. If one of these cells in a row contains a value then I don't want to hide it.

    Can you please help look at the above and suggest where I am going wrong.

    Also having trouble pasting one macro into another - whats the best way to import?

    Kind Regards
    Alex
    Last edited by a45ward; 06-02-2010 at 06:28 AM. Reason: Attachment needed

  2. #2
    Registered User
    Join Date
    06-02-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Hide all rows where a range of cells are blank

    I've posted an attachment which was in the other thread so you can roughly see what I mean.

    Thanks
    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)

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