Hide the rows not needed

Range("a1,a7,a10:a15").EntireRow.Hidden = True
'other code
Rows.Hidden = False
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Matt G" wrote in message
...
Hi,

I have a macro to import a file and sort by column A and set a page break
each time the value on column A changes. Next I only want to print
certain
rows on each page and I can't figure out how to do it.

For example, I only want to print row 2 if the value of cells P2 through
U2
are all zero(invidually, not a sum) and the value of cell V2 is zero.

Any thoughts?