Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print one line per page
In Excel 2003, I have a table, where each line represents one date. I'd like
to print each line (each date) on a separate page (because the hardcopy will go into separate documentation files). Each page will also include the page header and footer, and the header rows from the table. Obviously I could insert page breaks manually at every row, but the table contains dozens of rows and that seems like an unnecessary chore. Can anyone suggest an easier way? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print one line per page
Eric
This little macro will print each row as a separate print job. That will print each row on a separate page. HTH Otto Sub PrintEachRow() Dim rColA As Range Dim i As Range Set rColA = Range("A2", Range("A" & Rows.Count).End(xlUp)) For Each i In rColA i.Resize(, 5).PrintOut Next i End Sub "Eric" wrote in message ... In Excel 2003, I have a table, where each line represents one date. I'd like to print each line (each date) on a separate page (because the hardcopy will go into separate documentation files). Each page will also include the page header and footer, and the header rows from the table. Obviously I could insert page breaks manually at every row, but the table contains dozens of rows and that seems like an unnecessary chore. Can anyone suggest an easier way? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print one line per page
Adapted from http://excel.tips.net/Pages/T002792_...ge_Breaks.html
================================================== =========================== The following macro will do the trick: Sub PageBreak() Dim CellRange As Range Dim TestCell As Range Set CellRange = Selection For Each TestCell In CellRange ActiveSheet.Rows(TestCell.Row).PageBreak = xlPageBreakNone ActiveSheet.Rows(TestCell.Row).PageBreak = xlPageBreakManual Next TestCell End Sub To use the macro, simply "Eric" wrote: In Excel 2003, I have a table, where each line represents one date. I'd like to print each line (each date) on a separate page (because the hardcopy will go into separate documentation files). Each page will also include the page header and footer, and the header rows from the table. Obviously I could insert page breaks manually at every row, but the table contains dozens of rows and that seems like an unnecessary chore. Can anyone suggest an easier way? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print one line per page
"Sheeloo" wrote: Adapted from http://excel.tips.net/Pages/T002792_...ge_Breaks.html ================================================== =========================== The following macro will do the trick: Sub PageBreak() Dim CellRange As Range Dim TestCell As Range Set CellRange = Selection For Each TestCell In CellRange ActiveSheet.Rows(TestCell.Row).PageBreak = xlPageBreakNone ActiveSheet.Rows(TestCell.Row).PageBreak = xlPageBreakManual Next TestCell End Sub To use the macro, simply "Eric" wrote: In Excel 2003, I have a table, where each line represents one date. I'd like to print each line (each date) on a separate page (because the hardcopy will go into separate documentation files). Each page will also include the page header and footer, and the header rows from the table. Obviously I could insert page breaks manually at every row, but the table contains dozens of rows and that seems like an unnecessary chore. Can anyone suggest an easier way? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE | Setting up and Configuration of Excel | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
I need to print cells under the orginal line instead of page break | Excel Discussion (Misc queries) | |||
How do I remove repeating line in Excell - Top line on each page.. | Excel Worksheet Functions |