hi,
this will unhide all the rows in your sheet

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

--
David


"Daniel R. Young" wrote:

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