Headers - Different on Last Page - Can it be done

%3CLINGO-SUB%20id%3D%22lingo-sub-2260167%22%20slang%3D%22en-US%22%3EHeaders%20-%20Different%20on%20Last%20Page%20-%20Can%20it%20be%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2260167%22%20slang%3D%22en-US%22%3E%3CUL%3E%3CLI%3E%3CSTRONG%3EDevice%20and%20OS%20platform%3C%2FSTRONG%3E%2C%20PC%20-%20Windows%2010%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExcel%20product%20name%2C%20%3C%2FSTRONG%3EExcel%20365%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThe%20end%20result%20I'm%20after%20is%20PDF%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20multi%20page%20document%20%26amp%3B%20I%20need%20to%20change%20the%20header%20on%20the%20last%20page.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGoogle%20tells%20me%20it%20can%20be%20done%20by%20inserting%20a%20section%20break%2C%20I%20don't%20appear%20to%20have%20that%20option%20in%20the%20version%20of%20Excel%20I'm%20using.%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20through%20VBA%20%26amp%3B%20couldn't%20get%20it%20to%20work%3C%2FP%3E%3CP%3ENext%20step%20is%20to%20open%20the%20file%20on%20a%20different%20machine%20with%20a%20different%20version%20of%20Excel%20%26amp%3B%20see%20if%20I%20can%20get%20that%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20Ideas%20%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2260167%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
  • Device and OS platform, PC - Windows 10
  • Excel product name, Excel 365 

The end result I'm after is PDF 

I have a multi page document & I need to change the header on the last page. 

 

Google tells me it can be done by inserting a section break, I don't appear to have that option in the version of Excel I'm using. 

I've tried through VBA & couldn't get it to work

Next step is to open the file on a different machine with a different version of Excel & see if I can get that working.

 

Any Ideas ?  

0 Replies