2 Replies Latest reply: Aug 23, 2013 7:12 AM by Andrea Ghirardello RSS

    Changing Font in Macro

      I have exported a straight table data to Excel using macro.

       

      I have exoprted the table caption as a header in Excel.

       

      How can I make the caption into bold and change the font also?Please help.

       

      chartCaption1 = Left(tableToExport.GetCaption.Name.v,50)

      curSheet.Range("A1") = chartCaption1
         

       

       

      Thanks in advance..

       

      Soumya..