XL2000
is there a way to hide #VALUE! and ###### until needed or used

Is it possible to hide rows of formulas using a code

I know that I can hide them everyday by format rows/hide

today i will enter info in rows 25 and 26 but there is unused
information in rows 27 through 100
tomorrow i will enter info in rows 27 an 28 and so on

the unused rows have conditional formatting and it makes my eyes cross
looking at tomorrow's rows since
the conditional formatting is missing information
Thank you Alan at