Header and Footer Codes

&APrints the name of the workbook or worksheet tab ??
&BTurns bold printing on or off
&CCentres the characters to follow
&DPrints the current date
&[Date]Prints the current date
&ETurns double-underline printing on or off
&FPrints the name of the document
&[File]Workbook name
&ITurns italic printing on or off
&LLeft aligns the characters to follow
&NPrints the total number of pages in the document
&RRight aligns the characters that follow
&STurns strikethrough printing on or off
&TPrints the current time
&[Tab]Worksheet name
&UTurns underline printing on or off
&XTurns superscript printing on or off
&YTurns subscript printing on or off
&P+numberPrints the page number plus the specified number
&P-numberPrints the page number minus the specified number
&[Page]Current page number
&[Path]Folder path of the workbook
&[Picture]Picture has been inserted
&&Prints a single ampersand
& "fontname"Prints the characters in the specified font. Be sure to include the double quotation marks
&nnPrints the characters in the specified font size. two-digit number to specify size in points

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext