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