I have some VBA code that makes multiple copies of a chart object and
then populates the chart with series and title information.
Unfortunately, the font size for the chart title keeps on getting reset
to 16.5, even though I set it to 12 via VBA. I have no idea why this is,
and no error is listed. Any ideas on how to fix this would be really
welcome.

Further details:

Code used to duplicate the original chart object

Set co2 = co.Duplicate

Code used to rename and change font

co2.Chart.ChartTitle.Text = cYNav.getName
co2.Chart.ChartTitle.Font.Size = 12

where co2 is a ChartObject
cYNav is an object I created to store some info.

Thank you for your help.

Regards,

Viv.


--
Viv2004
------------------------------------------------------------------------
Viv2004's Profile: http://www.excelforum.com/member.php...o&userid=26511
View this thread: http://www.excelforum.com/showthread...hreadid=397944