Hiding blank rows using a macro



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!



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