PrintTitle using macro

  • Thread starter Thread starter Senthil
  • Start date Start date
S

Senthil

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
 
Try setting 1-8 and hide rows the non-desired rows>print>unhide
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I format data into columns using a pivot table report? 1
VBA CreateNames (ignores last 5 rows?) 6
Macro to Create Name Ranges for variable lengths of Data 9
Dynamic Offset from an Application.Goto cell = Date or Time 10
macro to show / hide grouping, linked to label button 3
Code in a macro to branch to another macro? 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Combine columns from seperate sheets into new sheet- macro improve 4

Back
Top