Excel Excel 2007 Issues

Joined
Feb 8, 2012
Messages
2
Reaction score
0
I just converted to Excel 2007 and am experiencing an issue I wasn't experiencing in Excel 2003. I have a macro that creates a chart then copies that chart to a separate worksheet. The issue is, I now get a Range Name conflict that I didn't get using the same VB code with 2003. Any ideas on how to resolve?
 
Joined
Sep 3, 2008
Messages
164
Reaction score
5
TMattO,

Can you post your macro and indicate the point it does not work? A sample of the data would be helpful as well.

Stoneboysteve
 
Joined
Feb 8, 2012
Messages
2
Reaction score
0
I've attached test data and the code that was used to produce it.
Try copying the chart to another chart in the same workbook - either "Copy/Move" or Ctrl+drag to the right. This will illustrate the issue I'm experiencing. I've also included the text of the macro that was used to produce the existing chart. Scroll down to section commented "Create Chart - Cumulative" to see where the issue occurs.

Thanks for your help. Hopefully its a simple fix!

Reminder -- Worked in Excel 2003, not in Excel 2007
 

Attachments

  • submittedTestData.zip
    19.5 KB · Views: 64

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

Top