Hiding blank rows using a macro

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!
 
O

Otto Moehrbach

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

Deleting blank rows with formulas in them 7
Macro to hide rows with zero values in columns 2
After Macro runs, no cell activated - what am I missing? 2
Using Macro to Hide Rows with Certain Values 2
Automatically Hiding Blank Rows 5
Macro for hiding zero data rows while printing 1
auto hiding blank rows and columns 5
Hide rows when specified columns equal zero 1

Top