Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PageBreak Macro with Hidden rows
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PageBreak Macro with Hidden rows
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PageBreak Macro with Hidden rows
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 "David" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
Cant move pagebreak in PageBreak View in Excel2003 | Excel Worksheet Functions | |||
Can I keep rows together so they don't separate at a pagebreak? | Excel Discussion (Misc queries) | |||
hidden rows when running a macro | Excel Programming | |||
PAGEBREAK-MACRO | Excel Programming |