Hello,

I am trying to see if I would need to create a VBA or MACRO to generate a count of worksheets in Excel or if it is possible to use a formula. I have a workbook with five sheets and I would like to have a cell on every worksheet that displays the worksheet number as pages?

I.E. Page 1 of 5, Page 2 of 5, etc.

Is there a quick and easy way for this function?

Thanks,

Nick