Print Area

[lekmx]

Dear Masters,

My tables are too long and I have a lot of pages. When I need to print I use Print Area.

The problem is:
"Just the first page has the head of the table, the page 2, page 3... have just numbers without head."

I need some VBA that go to he page 2 and 3 in the same sheet insert the head, until the last page in a Print Area.

Thank you very much

 

[Fluff]

Re: Print Area Challenge

Rather than vba you can do it like this
Select Page Layout tab > Print Titles > Rows to repeat at top enter $1$1

 

[lekmx]

Re: Print Area Challenge

OMG too easy lol, Fluff you are awesome, thank you!

 

[Fluff]

Re: Print Area Challenge

Glad to help & thanks for the feedback