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