Arnout Brandt
New Member
Hi all,
I encounter the following problem regarding the chartobject.
This is the situation:
1. I copy a chart from a master sheet to a new workbook using copy paste
2. In the target book I want to replace the formula from the seriescollection (because it is referenced to the master sheet).
Now this is what happens:
- when I run the code without breakpoints an error occurs.
- when I run the code with a breakpoint on the above mentioned line no error occurs and the code works fine.
Of course I am willing to provide more code, for now, without to many details, is any one familiar with this behavior?
Help is much appreciated.
Kind regards,
Arnout
I encounter the following problem regarding the chartobject.
This is the situation:
1. I copy a chart from a master sheet to a new workbook using copy paste
2. In the target book I want to replace the formula from the seriescollection (because it is referenced to the master sheet).
Code:
chtTarget.seriesCollection(i).formula = chtSource.SeriesCollection(i).formula
Now this is what happens:
- when I run the code without breakpoints an error occurs.
- when I run the code with a breakpoint on the above mentioned line no error occurs and the code works fine.
Of course I am willing to provide more code, for now, without to many details, is any one familiar with this behavior?
Help is much appreciated.
Kind regards,
Arnout