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?

Macro to hide rows with zero values in columns
 

which column or___________

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"K Dawson" wrote in message
...
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?

Macro to hide rows with zero values in columns
 

Columns B to F

"Don Guillett" wrote:

which column or___________

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"K Dawson" wrote in message
...
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?

.