Results 1 to 5 of 5

Increase header font size

Threaded View

Steven811 Increase header font size 04-21-2010, 03:32 AM
MarMo Re: Increase header font size 04-21-2010, 04:16 AM
Steven811 Re: Increase header font size 04-22-2010, 03:41 AM
MarMo Re: Increase header font size 04-22-2010, 04:07 AM
Steven811 Re: Increase header font size 04-22-2010, 06:29 AM
  1. #1
    Forum Contributor
    Join Date
    02-17-2005
    Location
    Wokingham
    MS-Off Ver
    365
    Posts
    111

    Increase header font size

    Hi

    I wish to increase the font size of the text in my header. This is the code that I've used to generate the text.

    Can anyone help

    Sub TE_Add()
    '
    '
    'Add D2 from active sheet to each sheets's header
        Dim ws As Worksheet
        For Each ws In ActiveWorkbook.Worksheets
                 ws.PageSetup.CenterHeader = "New Order"
            ws.PageSetup.RightHeader = ActiveSheet.Range("D2").Value
        Next ws
    End Sub
    Please note that I have previously posted this in general help and didn't receive any replies and believe that this form is more suitable.
    http://www.excelforum.com/excel-gene...in-header.html

    Thanks
    Steven811
    Last edited by Steven811; 04-22-2010 at 06:30 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1