Print Header..Change font size and also the colour

Posted 30 July 2012 - 05:31 PM

kirubagari
Hi Experts,

Kindly help.This is my header

I need to make the font size the LOTID string bigger compare to other string..The string was appended with other string ..How the lot id font size can be set bigger?
Im calling print header function and the size of the header is standadized..What need to be done if i want to make LOTID string font bigger?

 sHeader = "/cABC MALAYSIA SDN BHD" _ 
                 + "/n/cNYNAME" _ 
                 + "/n/cNEWYORK , UNITED STATE" _ 
                 + "/n/n/c SUMMARY" _ 
                 + "/n/n/lLOT ID: " + rc.Lot.Id + "/n" 
      '  Define the header text 
     Me.vaTestData.PrintHeader = sHeader

vatestData is the spreadsheet.

Kindly help