How can I pass external variable in excel macro for header? : I'm printing no of pages in right header (eg. Page 1 of [total no of pages]) I want to pass my variable after &P of &fcount(fcount is my variable). How can I pass this?