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 |
All times are GMT +1. The time now is 12:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com