&D

Prints the current date

&T

Prints the current time

&F

Prints the name of the document

&A

Prints the name of the workbook tab (the "sheet name")

&[File]

Also prints file name

&[Path]

Prints path

&[Picture]

Opens dialog box to select graphic (2003)

&P

Prints the page number

&P+number

Prints the page number plus number

&P-number

Prints the page number minus number

&&

Prints a single ampersand

&N

Prints the total number of pages in the document

• Use CHR(10) to insert a linefeed character.
  
• Use CHR(13) to insert a carriage return character.

The article also includes the VBA to create a macro that will insert header/footer information.
Microsoft KB213618

Also:

Daily Dose of Excel:
Formatting Footers in VBA




See all Topics