HeaderPgNDilemma

[andloch]

Hello All, new user.

I'm using excel 2003, and have inserted a header using the 'Sheet' section of (View - Header and footer), selecting rows and columns that I want to 'head' for each page.

The problem is that in one of these cells in the header, the current page number is displayed, so when I look at all the other pages, it still reads page 1.

Is there a way of adding in a counter/formula/macro or something to this cell so it can display the correct page number in each header section of each page?



Many Thanks

[TMS]

You'd be better using the standard header/footer in Page Setup rather than re-inventing the wheel.


Regards