View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roady Roady is offline
external usenet poster
 
Posts: 69
Default Macro - hide rows that are 0 without an auto-filter

Hello:

I would like a macro to review rows 7-435 and if Col F = zero, then hide
that row so that only rows that contain 0 show at the completion of the
macro.

I can't add an auto-filter to help acheive this because I already have an
auto-filter on a section that is located beneath row 435.

Any ideas?

thank you!