Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple print title rows
Chris,
You can print out more than one row in the headers. So you set the print titles and the print area with the following: With ActiveSheet.PageSetup .PrintTitleRows = "$1:$3" .PrintTitleColumns = "" .PrintArea = "$4:$16" End With and then print it out and then you set the print titles and the print area again with the following: With ActiveSheet.PageSetup .PrintTitleRows = "$30:$32" .PrintTitleColumns = "" .PrintArea = "$33:$166" End With and then print it out. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "ChrisO" wrote: Hello, I have a worksheet with two sections of data, both of which may spread across multiple pages in printed output. Each section has a different set of column headers, which I want to use as the title row for each printed page. I am familiar with using the PrintTitleRows property but this only allows me to have one title row(s), which is fine for the first section but not for the second one. Can anyone tell me if there is a way (in a macro) to set up separate title rows for different sections of a single worksheet. Many thanks. Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Title | Excel Worksheet Functions | |||
Print Title Error | Excel Discussion (Misc queries) | |||
how print title for only first 9 of 10 pages? | Excel Discussion (Misc queries) | |||
format rows to print at top for multiple tabs | Setting up and Configuration of Excel | |||
print multiple, separate rows on each page | Excel Discussion (Misc queries) |