Hi,
I have an application that generates an Excel spreadsheet of varying length as a solid body with "Rows to repeat at top" marked as a header for multiple pages. It needs a number of current page and total amount of pages printed. Now, I know about a standard Excel header/footer feature in Page Setup where you can write "&[Page] of &[Pages]"... problem is, bosses won't accept it. Both numbers have to be explicitly present in sheet's cells, and even if I somehow calculate the total amount of pages from the amount of lines, I have no idea how to make the same "Current page" cell from header band produce different values on different pages. Is there a way to get those numbers as a function, or I have to re-tailor the app to manually insert the header band into each page just because of this dumb requirement?
Thanks.
I have an application that generates an Excel spreadsheet of varying length as a solid body with "Rows to repeat at top" marked as a header for multiple pages. It needs a number of current page and total amount of pages printed. Now, I know about a standard Excel header/footer feature in Page Setup where you can write "&[Page] of &[Pages]"... problem is, bosses won't accept it. Both numbers have to be explicitly present in sheet's cells, and even if I somehow calculate the total amount of pages from the amount of lines, I have no idea how to make the same "Current page" cell from header band produce different values on different pages. Is there a way to get those numbers as a function, or I have to re-tailor the app to manually insert the header band into each page just because of this dumb requirement?
Thanks.