Excel 2007 Macro Problem
On Dec 9, 10:13 pm, Robby wrote:
I was just wondering if anyone knows what this message means:
"Method 'Axes' of object' _Chart failed"
The Macro works fine in Excel 2003 but crashes in Excel 2007. The line which
seems to be casuing me grief is:
ActiveChart.Axes(xlCategory, xlPrimary).CategoryType = xlCategoryScale
Could anyone let me know what the problem could be.
Microsoft.
They withdrew that functionality and added a different "improved" way
of doing it.
XL2007 graphs and charts are now an order of magnitude slower too.
Stick with 2003 until they get 2007 into decent working order.
Regards,
Martin Brown
|