View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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