Different fonts names and size used in header excel

  • Hi guys

    i am finding it difficult to set right header using multiple fonts. i am using below code which takes the value from cell and change font type and size.

    Application.ActiveSheet.PageSetup.RightHeader = "&""Calibri""&45 " & Range("H20").Value

    if i want to add another cell to header, lets say H21 but with a different font, lets say times new roman and size 20 what should i add in the above code.

    Any help will be appreciated


Participate now!

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