Hi,

How to extract the printing page numbers from my worksheets in order to update my 'table of contents' worksheet automatically?

The sheets are named Part 1, 2, etc. and they all have a 'Part x - Cover' worksheet. I only want the page numbers of the 'Part x' worksheets, not for the covers.

I am looking for a solution that doesn't involve having to press a button or run a macro. In other words a function. Also, because I have not got to grips with VBA programming, I have placed this thread in the forum 'Excel Worksheet Functions'.

Thanks!