Jul 14 2022 04:01 AM
Hi
is there an Excel 365 VBA command to return the current page number of a sheet?
Assume I have a sheet with three pages. I want to display the sentence "Page 1 of 3" on the first page, "Page 2 of 3" on the second page, and "Page 3 of 3 " on the third page. I do not want to use the footer. I can count the total pages but how do assign the individual pages.
Regards
Jul 15 2022 06:38 PM