I have a spreadsheet that has data in columns a through J, cells 5 through 16. I want to create a macro to hide a row within that area in which column H is blank. TIA!
I have a spreadsheet that has data in columns a through J, cells 5 through 16. I want to create a macro to hide a row within that area in which column H is blank. TIA!
Hi, Triscia,
if the cells are blank (no formulas):
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Awesome. Thank you. Is there another code to add to unhide them. TIA!
Hi, Triscia,
of course (weŽll stay with one line of code):
No Error handling necessary for this one.Please Login or Register to view this content.
Ciao,
Holger
Thanks for the quick response, but I have one more question that is kind of multiple. I am really trying to hide multiple rows in different locations within this document. I actually have a title called Statement of condition and any cells H5:h16 that are blank I want hidden, which that worked, but I have other titles in the same worksheet that I want to hide using the same, if column H is blank. So all in all I want to hide any blank cells in column h from H5:h16, again from h19:h38 and again at h41:h54. There are a total of 12 different places that I want to do this at. Is this something that can be done. Thank you so much for your help!
Hi, Triscia,
this is just one way to maybe solve this:
This code will take the areas one by one and try to hide empty cells. If none are in the area a MessageBox will you inform you about that. Please note that this code will take action on the active sheet in the workbook.Please Login or Register to view this content.
To show all rows you may use
Ciao,Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks