How to hide row 1 if there are no entries on the cells B1 to G1

[PMPMagalhaes]

Hello Folks,

I need your powerfull support on this.

So, I have a row 1, where A1 is a text I cannot erase and B1-G1 is filled depending on formulas IF (these cells can be returned empty "" or a specified text).
I need to find a way to hide the entire row if cells B1-G1 are empty.

After need to export to lines 1 to 10.

I think I need a macro. Correct? Can you help me?

Thanks on advance!

[kev_]

Beware - a cell is not empty if it contains a formula - and this is the case here.
This will work if formulas result in "" (empty string)

Please Login or Register  to view this content.

[kev_]

or perhaps

Please Login or Register  to view this content.