Gets or sets the format of the right part of the footer. Formatting and VBA codes for headers and footers are below.
&L - Left aligns the characters that follow.
&C - Centers the characters that follow.
&R - Right aligns the characters that follow.
&E - Turns double-underline printing on or off.
&X - Turns superscript printing on or off.
&Y - Turns subscript printing on or off.
&B - Turns bold printing on or off.
&I - Turns italic printing on or off.
&U - Turns underline printing on or off.
&S - Turns strikethrough printing on or off.
&"fontname" - Prints the characters that follow in the specified font. Be sure to include the double quotation marks.
&nn - Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points.
&color - Prints the characters in the specified color. User supplies a hexidecimal color value.
&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.
&P - Prints the page number.
&P+number - Prints the page number plus the specified number.
&P-number - Prints the page number minus the specified number.
&& - Prints a single ampersand.
&N - Prints the total number of pages in the document.
&Z - Prints the file path.
&G - Inserts an image.
Namespace: Winnovative.ExcelLib
Assembly: wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)
Syntax
Property Value
Type: StringSee Also