Hello,
I have searched for this sol but could not find one I am looking at.
I have multiple tabs and each tab may have multiple page breaks. I know to get the print out I can use Page number from footer. But I need to know a function or macro that will let me know which page number I am on. I could not go every time and check this. The 1st tab should be 1 page and second pg break should be page 2 and it should move to other tab and continue the page numbering just like what you get in the footer when priniting the whole file. but I need the page numbers to tick n tie in my process. For e.g. say on page 2 I need to compare the amount, I need to know on which page the other but same amount is. or from any page (eg 10 or 18), if I know the page number I can easily mention the page number agaist the amount. And If I hane over the print pakage to anyone they are manually turn to that page and check tha balance.
Hope I am clear to explain. I checked the site but only could find page break in single sheet.
Thank you
I have searched for this sol but could not find one I am looking at.
I have multiple tabs and each tab may have multiple page breaks. I know to get the print out I can use Page number from footer. But I need to know a function or macro that will let me know which page number I am on. I could not go every time and check this. The 1st tab should be 1 page and second pg break should be page 2 and it should move to other tab and continue the page numbering just like what you get in the footer when priniting the whole file. but I need the page numbers to tick n tie in my process. For e.g. say on page 2 I need to compare the amount, I need to know on which page the other but same amount is. or from any page (eg 10 or 18), if I know the page number I can easily mention the page number agaist the amount. And If I hane over the print pakage to anyone they are manually turn to that page and check tha balance.
Hope I am clear to explain. I checked the site but only could find page break in single sheet.
Thank you
