Macro to list page number from the sheet

[umberto79]

Hello Experts,

Here is another issue I'm facing.Maybe someone know how to get around it.

I have a workbook with multiple sheets.On the first page "main page" I'm getting sheet names using macro.
Now next to the sheet names I want to get a first page numbers of the sheets (taken from the left footer of each sheet, based on the name from the list of sheets from Main page ).However....pages needs to be a continuation of previous sheet pages.
For example: if sheet1 have 3 pages , then sheet2 first page number will be 4....and sheet2 have 2 pages so sheet3 first page will be 6 .And this is how I would like to have it listed:
sheet1: page 1
sheet2: page 4
sheet3: page 6


I have some macro doing this but the issue is it is not getting the page numbers only some formats from the footer.Probably I'm doing something wrong.
I have attached a file whith macro.

Much appreciate for anyone help.
Umberto

[karedog]

Maybe :

Please Login or Register  to view this content.

[umberto79]

karedog,

Amazing Works very,very well.

Many thanks for Your time and help.

Umberto

[karedog]

You are welcome, thanks for marking the thread as solved and rep.points given.

Regards