title: How do I change the chart title font size in a loop using VBA?
body: <p>I want to create some VBA code that runs through every sheet, making the chart title <code>font size = 18</code>, chart axes <code>font size  = 16</code>, the <code>chart width = 6</code>, and <code>chart height = 12</code>. Currently having a hard time with the font size inside a loop</p>
  
  <blockquote>
    <p>Getting error: Object doesnt support this property or method</p>
  </blockquote>
  
  <pre><code>     Sub ResizeCharts()   'Make all charts on active sheet uniform size.  
  
         Dim cht As ChartObject 
  
         For Each cht In ActiveSheet.ChartObjects
          cht.Height = Application.InchesToPoints(6)
          cht.Width = Application.InchesToPoints(12)
          With cht.ActiveChart
               With .ChartTitle
                   .Size = 18
               End With
           End With  
         Next 
  
       End Sub
  </code></pre>