VBA for Hiding Rows with Errors
One way is to select the range to examine.
edit|goto|special
check Formulas (or Constants)
uncheck everything except errors
Then Format|row|hide
If you need a macro, then record one when you do it manually.
Wynn wrote:
Only have basic VBA knowledge and was hoping you guys could help me here. I
want some code to hide all rows that have errors (i.e. REF, div/0, etc.)
I figure this should be pretty easy but haven“t quite gotten it right....
--
Dave Peterson
|