I was wondering if theres a macro to display sheet numbers in specified cells... For example I have 3 sheets printed... I want to have a specific columns and cells that will display whether it's sheet 1 of 3, sheet 2 of 3... ect...
Any ideas??
I was wondering if theres a macro to display sheet numbers in specified cells... For example I have 3 sheets printed... I want to have a specific columns and cells that will display whether it's sheet 1 of 3, sheet 2 of 3... ect...
Any ideas??
Hi iamjess147
I think the code you need is as follows
In your specified cell, enter the formula =SheetPage() and it should give you the required sheet information.Please Login or Register to view this content.
Regards
File > Page Setup > Header/Footer, press Custom Header (or Custom Footer). There are buttons for page number and total pages.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks