A
~Alan Rosenberg Miami
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 (e-mail address removed)
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 (e-mail address removed)