LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default set header font size using a variable?

I am trying to set the header font size to a variable (I just am using a
constant in this example), but am having no luck getting it to print. I have
tried many attempts but am not getting what I need. So far I get no header
or some other formatting (time, strikethrough, etc). Please help. Thanks in
advance.

FS = 36

..CenterHeader = "&""Times New Roman,Bold" & FS & "ATTACHMENT I"
does not work

..CenterHeader = "&""Times New Roman,Bold""&FSATTACHMENT I"
does not work either
 
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
Changing Font color based on font type or size John Excel Discussion (Misc queries) 2 February 7th 08 12:50 AM
Change all text one font size up with various font sizes used. omchrystal New Users to Excel 2 March 6th 07 09:01 PM
Header Font size Mike Fogleman Excel Programming 3 June 22nd 05 01:12 AM
Dropdown list for font size, font type and number formats ExcelMonkey[_190_] Excel Programming 1 March 9th 05 03:50 PM
Change Header Font Size Bret Excel Programming 2 October 27th 04 04:19 PM


All times are GMT +1. The time now is 07:28 PM.

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

About Us

"It's about Microsoft Excel"