Converting VBA about charts to 2007

B

Brandon Penner

Hi all, I am in the process of converting my VBA program to Excel 2007 and am
getting an error with the following line that is stumping me. Any help
appreciated. Thanks!

ActiveChart.Axes(xlCategory, xlPrimary).CategoryType = xlAutomatic

The error reads:
"Run-time error '-2147467259(80004005)':
Invalid Parameter"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bubble Charts 0
Charts in Multiple Sheet in Excel 1
error message Method ‘Add’ of object ‘CommandBar Controls’ fail? 2
Bizarre chart behaviour when changing axis cross at points 2
Excel 2007 Macro Problem 9
Macro for Graph - problem with Range 2
Access to Excel 2007 curious behavior 0
Axes(xlCategory) for a chart-sheet in 2007 2

Top