Count worksheets in header

H

Hammer_757

In a workbook I need the Header to read “Page X of X”, whic
is easy if I want the to count pages within the worksheet but I need th
page count to be based on the worksheets. So if I have 2 worksheets th
header on the first worksheet would read “Page 1 of 2” an
the second sheet to read “Page 2 of 2”

How can I do this?

Thanks
Rober
 
Top