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....

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

    Thank you in advance for your time.


  • 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.

Participate now!

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