+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : I need a macro for a button to hide blank cells but not header row.

  1. #1
    Registered User
    Join Date
    02-08-2010
    Location
    Calgary
    MS-Off Ver
    Excel 2003
    Posts
    2

    I need a macro for a button to hide blank cells but not header row.

    Hi everybody,

    This is the first time I have posted something on a forum, but I cannot seem to find the solution to my problem no matter where I look.


    I need a macro for a button that will hide blank cells in a named range. The problem is that the named range has a header row, I want the macro to hide ALL rows including header if the rows below the header are blank, but only hide blank rows if and leave header row if there is information entered.

    This would be easier if I didn't have the header to worry about, I could just do a macro to hide all blanks. But it would not hide the header, I DO want it to hide the header though if the rest of the rows are blank.

    Any help would be greatly appretiated. Thank you all and have a great day.
    Last edited by Genoel; 02-08-2010 at 08:42 AM.

+ 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