View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
K Dawson K Dawson is offline
external usenet poster
 
Posts: 3
Default Macro to hide rows with zero values in columns

Hi,
I've got a large workbook with a minimum of 75 sheets of data. Each sheet
contains 8 columns and 237 rows. Many of the rows in the report have zero
values in the columns. I'd like to create a macro that will hide all rows
with zero values in all sheets.
Any suggestions?