| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Need to format text in header, but value is generated using VBA
Hello,
I wanted to reference a cell value in my spreadsheet header and found out how to do that using this function: Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim WS As Worksheet For Each WS In Worksheets ActiveSheet.PageSetup.RightHeader = _ Format(Worksheets("Time Period Info").Range("B3").Value) Next WS End Sub However, this leaves my text for this portion of the header at Arial Size 10 font Regular. I would like it Arial Size 20 Bold. How can I set it to this format of text? Thanks for the help! --Stacey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
| Custom Number Format Text | Excel Discussion (Misc queries) | |||
| How do I set Excel cell format to "Text" from VB.NET? | Excel Discussion (Misc queries) | |||
| format the "date" button for a header | Excel Discussion (Misc queries) | |||
| Problem with wrap text format | Excel Worksheet Functions | |||
Threaded Mode
