Macro to hide rows with zero values in columns
in [General]
|
From: K Dawson on 11 Feb 2010 12:48 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?
From: Don Guillett on 11 Feb 2010 13:03 which column or___________ -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "K Dawson" <KDawson(a)discussions.microsoft.com> wrote in message news:102EED61-5B56-4342-9151-65AFCA84E13F(a)microsoft.com... > 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?
|
Pages: 1 Prev: Error msg on opening excel workbook Next: Word Art won't show up in Print Preview |