What does &L& mean in a page setup macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros in Excel 2
Recording simple macro 5
variables in footers 1
XL4 error executing Page.Setup function 2
Page Setup not working in macro 1
Adapting Excel 4 Macro Page Setup for multiple pages 1
Importing text into a Text Box 2
Page setup error after moving sheet tabs 3

Back
Top