Thread: Macro to hide rows with zero values in columns
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
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?

.

Reply With QuoteReply With Quote