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?
Excel Excel 2007 Issues
- Thread starter TMattO
- Start date
- 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
Can you post your macro and indicate the point it does not work? A sample of the data would be helpful as well.
Stoneboysteve
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
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