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?

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?

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" wrote:

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?

If desired, send your wb to my address below along with this msg,
explanation, and before/after example
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Matt G" wrote in message
...
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" wrote:

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?