Filter and un-filter reveals my hidden rows. How to keep hidden?

[Caveman1964]

I've tried several things and searched but can't find an easy solution.
I have approx 400 sporadic hidden rows that i'm hiding formulas. When I filter, and then remove filter, my previously hidden rows are revealed.
Is there a way to keep them hidden?
I used a macro to filter as well and see I may be able to write a code to rehide them buts its a lot of rows.
any ideas?

 

[Joe4]

What I would recommend doing is adding another column and populate it for these hidden rows with a value like "hidden".
Then include in your filter criteria for this column to hide those rows in addition to what you are trying to filter.

 

[Caveman1964]

What I would recommend doing is adding another column and populate it for these hidden rows with a value like "hidden".
Then include in your filter criteria for this column to hide those rows in addition to what you are trying to filter.

Good idea...thank you.

 

[Joe4]

You are welcome!