Thread: hide rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default 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

Reply With QuoteReply With Quote