hide rows
 

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

hide rows
 

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" (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