Hide Row if Rows are Hidden

[reba0729]

Can I write a VBE so that (for example)

If Rows 10:20 are hidden,
then hide Row 9

Does anyone know how I can do this?

[Solus Rankin]

I am guessing there is more to the problem?

Hiding a single sheets is as easy as right clicking the tab and clicking hide, what is the value of automating this?

[stnkynts]

Solus is right. Giving you the answer to your specific question is easy. But I highly doubt it will solve your true problem.

Please Login or Register  to view this content.

[reba0729]

RG WORKING_3.xlsm

I have a range of cells that pull from a separate sheet. When the row returns a blank, I have code to hide that row.

Between sections of rows there is a gray "divider" row. If everything in the section returns a blank all of the rows in the section will be hidden. If all the whole section is hidden, then I want the divider row to hide as well. I'm attaching my workbook for reference. See the "Tracking" Sheet.

Thank you!

[stnkynts]

Replace your current HideOnEmpty macro with this one. Much faster. If it works for you feel free to click the star in the bottom left corner.

*Note: The only way I could think of working this was based upon the color of the "grey" line. If that color changes or you choose a different but similar color in the future, it won't work.

Please Login or Register  to view this content.

[reba0729]

This is awesome! Thank you so much!!!