Hiding blank rows using a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I write a macro that will hide rows that contain all zeroes in a
certain field. For example, if columns B:N are blank for rows 5-8 contain
only zeroes, how do I tell the macro to hide these rows IF those columns are
blank? Preferrably I'd like this to work for the whole worksheet. Thanks!
 
You're not clear on what you want. Do you want to hide the rows if those
columns are blank or if they have zeros. A zero and a blank are not the
same thing. Also, what do you mean when you say you want this to work for
the whole sheet? HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to hide rows with zero values in columns 2
How do you hide multiple row macro 1
Macro to hide rows with zero in specifc column range 2
Hide rows when specified columns equal zero 1
Deleting blank rows with formulas in them 7
Using Macro to Hide Rows with Certain Values 2
auto hide blank rows 1
macro to hide columns with zero values? 2

Back
Top