ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What does &L& mean in a page setup macro? (https://www.excelbanter.com/excel-worksheet-functions/101556-what-does-l-mean-page-setup-macro.html)

Bonnie June

What does &L& mean in a page setup macro?
 
I am trying to troubleshoot an error in a macro, can anyone tell me what the
error is in this string.
=PAGE.SETUP("&L&""Arial Narrow,Regular""&8Audit Bureau of
Circulation&C&""Arial,Bold""&9CIRCULATION RECORD","&R&""Marigold""&8Circ
Finance",0.5,0.25,0.5,0.5,FALSE,FALSE,FALSE,FALSE, 1,1,56,1,1,FALSE,-1,0,0,FALSE,FALSE)

[email protected]

What does &L& mean in a page setup macro?
 
long time since I have used this syntax but the first section is
&x&y&z = position, font, size
&L = left
&C = centre
&R = right
&8 = 8pt
&9 = 9pt
followed by print margins etc
PvO

Bonnie June wrote:
I am trying to troubleshoot an error in a macro, can anyone tell me what the
error is in this string.
=PAGE.SETUP("&L&""Arial Narrow,Regular""&8Audit Bureau of
Circulation&C&""Arial,Bold""&9CIRCULATION RECORD","&R&""Marigold""&8Circ
Finance",0.5,0.25,0.5,0.5,FALSE,FALSE,FALSE,FALSE, 1,1,56,1,1,FALSE,-1,0,0,FALSE,FALSE)




All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com