Forum Discussion
IF FUNCTION TO HIDE A ROW
I'm very new at this. I am trying to hide a row on a sheet when there's no data in it. I have 10 sections of rows, each section containing 6 rows. Sometimes I might have data in 4 of them and I would...
Formulas return only values to the cells and nothing else, you can't change properties of the cell or perform any command with formula. That's VBA programming.
But perhaps it's easier to apply the filter and hide all rows with zero by it.
SergeiBaklan Thank you for the clarification.
