Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Claus,
Understanding and using the xl4 code for page setup was a major undertaking for me. I won't admit how long it took. I don't think it can be learned without the xl4 function help file... http://makeashorterlink.com/?B24052ACB "&nn Prints the characters that follow in the specified font size." I have used it this way... Dim nn as Long Dim Head as String dim strNumber as String nn = 12 strNumber = "&" & nn Head = """&L" & strNumber & "Printed on &D" & "&C" & strNumber & _ Application.OrganizationName also... the formatting codes for xl4 and later versions of Excel appear to be the same... Dim WordToUse as String WordToUse = "Never Upgrade" WordToUse = "&""ChevaraOutline,&B""&20" & WordToUse That should change the font to ChevaraOutline, make it bold and size 20. Regards, Jim Cone "Claus" wrote in message ... Hi again I can't control the font. Is is possible ? How ? Regards, Claus Claus, Not much help here, just some comments/questions... The John Green code (as is) works for me in xl2002. The xl4 code is very sensitive and all of the quote marks are required. Are you using Option Explicit and does your code compile? Arguments for margins are always in inches, regardless of your country setting. Regards, Jim Cone San Francisco, USA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
Excel page setup Sheet Print Cells Error As... | Excel Discussion (Misc queries) | |||
ExecuteExcel4Macro Page.Setup Runtime Error | Excel Programming | |||
Error 1004 - unable to set the orientation of the page setup class | Excel Programming |