Printing macro, selected rows only

[Matt G]

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?

 

[Don Guillett]

Hide the rows not needed

Range("a1,a7,a10:a15").EntireRow.Hidden = True
'other code
Rows.Hidden = False

 

[Matt G]

Hi Don,

It is hiding the rows listed but I need it to hide rows based on the values
of the cells below. I'm fairly new at this so maybe I'm missing something.
The 'other code I assumed was the "sheets.printout" commands. Where am I
going wrong?

 

[Don Guillett]

If desired, send your wb to my address below along with this msg,
explanation, and before/after example