J
Josip.2000
Hi!
I'm working on a document that needs to allow the user to add more
"rows" (a "row" contains a list of numbers and a chart depicting these
numbers).
The problem however is that when copy-pasting new "rows", the charts
in the new "row" point to the numbers in the original "row" above.
Is there a a way to make this operation userfriendly? A macro maybe?
I tried to make some kind of macro but due to my limited skills I
don't seem to get it right. For example, how do I select a specific
chart from the new row (a row can contain up to 10 charts) when I
don't know it's name? (Example: ActiveSheet.ChartObjects("Chart
7").Activate --- does not work, since Chart 7 isn't dynamic...)
Any other solutions?
BR,
Josip
I'm working on a document that needs to allow the user to add more
"rows" (a "row" contains a list of numbers and a chart depicting these
numbers).
The problem however is that when copy-pasting new "rows", the charts
in the new "row" point to the numbers in the original "row" above.
Is there a a way to make this operation userfriendly? A macro maybe?
I tried to make some kind of macro but due to my limited skills I
don't seem to get it right. For example, how do I select a specific
chart from the new row (a row can contain up to 10 charts) when I
don't know it's name? (Example: ActiveSheet.ChartObjects("Chart
7").Activate --- does not work, since Chart 7 isn't dynamic...)
Any other solutions?
BR,
Josip