Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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)
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXcel 2003 Page setup slow Ian Excel Discussion (Misc queries) 5 April 22nd 10 12:48 PM
Page Setup changes Loris Excel Discussion (Misc queries) 0 March 7th 06 04:57 AM
Page Setup Across Multiple Worksheets Mike Excel Worksheet Functions 0 February 9th 06 07:31 PM
how dio i copy page setup formats from 1 spreadsheet to another? mike New Users to Excel 1 September 21st 05 10:27 PM
How can I Copy "Page Setup" Settings between Workbooks CJPodd Excel Discussion (Misc queries) 2 September 16th 05 05:58 PM


All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"