Formatting Header From Macro

  • I have a VBA macro that inserts a cell value into my header. What I would like to do is change the format of the inserted information (make it BOLD, change font size, etc.).
    The line of code I have is this....

    Code
    With ActiveSheet.PageSetup
    .CenterHeader = Range("a13").Value


    Thank you in advance for your time.


    Chuck

  • Re: Formatting Header From Macro


    Try recording amacro while you set the formattngthat you desire here what I just recorded. Look like all you may need is the .CenterHeader line.

  • Re: Formatting Header From Macro


    Tom and Ross,


    That is what I needed and it worked like a charm!
    Thanks to both of you for taking the time to help.


    Chuck

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!