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.
Bookmarks