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

Advertisements

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

Top