Title block printing help

[beca]

Hi there

I have a spreadsheet that has 3 pages long when it is printed out. It has a title block at the top, and has "page number" information in it.

I would like the title block to be shown on every page of the spreadsheet in the print out, and what I have done is to go to "page layout" ribin, then "print titles", and select the title block area under the "rows to repeat at top" function. However, the problem is the page number information doesn't update, such that its got page 1 on all the pages when it is printed out.

Ideally, page 1 would have "page 1" in the title block, page 2 would have "page 2" in the title block, and page 3 would have "page 3" in the title block.

Can someone help me on this? Please don't tell me to use header and footer as it is not ideal for this project. It would be good if it can be done without VBA code.

Thank you
<!-- / message -->

 

[Gerald Higgins]

Why don't you want to use headers and / or footers ?

The only solutions I can think of are
1) use headers and / or footers
2) insert page numbers manually, but make sure they are not in the header rows that you are using to show the title block.