Re: $$Excel-Macros$$ Changing Embedded Chart Axis Label Font Fails

2015-09-13 Thread Dan McDonald
Sam, Thank you for your reply. I will have to think through what is important to duplicate in a workbook to get the error message. I cannot send the original as it has business confidential information in it. I have a worksheet with a Pivot Table in it. On the same worksheet I have a spread

Re: $$Excel-Macros$$ Changing Embedded Chart Axis Label Font Fails

2015-09-11 Thread Sam Mathai Chacko
Dan, can you attach a sample file with just one chart and the code On Fri, Sep 11, 2015 at 8:25 PM, Dan McDonald wrote: > I have an unexpected problem trying to do something simple. I merely want > to change the font size of Axis(XlValue) on an embedded chart. > > My VBA code (from record ma

$$Excel-Macros$$ Changing Embedded Chart Axis Label Font Fails

2015-09-11 Thread Dan McDonald
I have an unexpected problem trying to do something simple. I merely want to change the font size of Axis(XlValue) on an embedded chart. My VBA code (from record macro) is shown below with the offending line pointed to. ActiveSheet.ChartObjects("Chart 6").Activate ActiveChart.Axes(xlVal