Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PrintTitle using macro
Hi All
I need a macro that prints a set of rows as Rowtitle. I need to combine two sets of rows as rowtitle. As much as i tried excel takes the rows contiuously as specified. eg : sht.PageSetup.PrintTitleRows = "$1:$5" - this sets the pagetitle from row 1 to row 5. My requirement is that i need to print rows 1 till 3 and combine it with rows 6 till 8 as one rowtitle. How do i acheive this?? (This i need it because the second set of rows is dynamic, i have to determine based on a condition and then i need to combine that with the first set of rows that is mostly static.) Thanks and Regards Senthil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PrintTitle using macro
Try setting 1-8 and hide rows the non-desired rowsprintunhide
-- Don Guillett Microsoft MVP Excel SalesAid Software "Senthil" wrote in message ps.com... Hi All I need a macro that prints a set of rows as Rowtitle. I need to combine two sets of rows as rowtitle. As much as i tried excel takes the rows contiuously as specified. eg : sht.PageSetup.PrintTitleRows = "$1:$5" - this sets the pagetitle from row 1 to row 5. My requirement is that i need to print rows 1 till 3 and combine it with rows 6 till 8 as one rowtitle. How do i acheive this?? (This i need it because the second set of rows is dynamic, i have to determine based on a condition and then i need to combine that with the first set of rows that is mostly static.) Thanks and Regards Senthil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |