Dynamic Header with multiple possibilities

[ardykav]

I have a file which can have anywhere between 5 and 500 rows to print. On the top of each page there should be a header but depending on the data below it the header will change thus I cant use the generic header function. I have some coding in that will hide rows if they have no data in them which means that the print ranges change a lot. My question is, is there some coding that I can use to place one of the 3 header options at the top of each page depending on where the page breaks are? To add an extra layer of complexity the sheet is entirely made up of formulas so putting in a formula for the header will erase formulas that are there and could cause issues for the next time any code is ran.

thanks in advance

 

[Legacy 456129]

Suspect you need a For Next loop that parses the Nth row for each page, so really, it becomes Evaluate, Print page 1, Evaluate, print page 2 and so on.

Here's some info for formatting the header itself and how to print row info at top of the page

Formatting and VBA codes for headers and footers

Office VBA reference topic

docs.microsoft.com

Print rows with column headers on top of every page - Microsoft Support

If a worksheet spans more than one page, you can print row or column headers or labels (also called print titles) in the first row or mutliple rows on every page.

support.office.com

 

[ardykav]

Thanks for that I’ve gone for a workaround of defining print ranges and then formulating the headers.