PageBreak Macro with Hidden rows

[Daniel R. Young]

I would like to create a macro for a report that I am creating. The report
is linked to a survey and the yes and no questions will hide and unhide rows
within the report. I would like to generate a pagebreak macro that will only
show the unhidden rows in the report. Right now the rows that are hidden
print a blank page. Can any one assist me?

Thank you,
dAniel

 

[David]

hi,
this will unhide all the rows in your sheet

Sub Macro1()
Cells.Select
Selection.EntireRow.Hidden = False
Range("A1").Select
End Sub

 

[Daniel R. Young]

David
I actually do not want to unhide all the rows. My report only shows the
questions that are deficient. So the hidden rows are questions that meet the
standards and are addequete, so I have no recommendations for them. I would
like those to remain hidden and print only those that are visible/unhidden.
The issue I face is when I did the page breaks for each page (255 total) the
hidden rows will still print as a blank page. I would like to deactivate
this and make sure that only the unhidden rows print.

Any ideas?

Thank you,

Daniel