hide rows

G

Guest

hi,

I would like to know how I can hide rows with zeroes in them. I have some
rows with all zeros in them for each column, and need them to be hidden.

0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0


Thanks in advance,
geebee
 
J

Jim Cone

Calculate the "Sum" of the row cell values, if it is zero then hide the row.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"geebee" <[email protected](noSPAMs)>
wrote in message
hi,
I would like to know how I can hide rows with zeroes in them. I have some
rows with all zeros in them for each column, and need them to be hidden.

0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0

Thanks in advance,
geebee
 

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

Need VBA solution to find 1st and 2nd occurrences of non- zero, thenreturn column header value 4
Displaying zeros in cells 2
Border formatting row of cells 22
A data validation question 1
Looking For A Formula 34
For-Next by a row Counting consecutive Zero in the column 4
Run select query from VBA code where criteria comes from a multi select ListBox 2
Can Vba workout if a selection is part of a group? 0

Top