M
MMD
I have written code for users to specify a worksheet and range or named range
that is then copied to PowerPoint Slides.
For example: If a Chart is on a Sheet named "Revenue" and in cells B4:T64,
the user just adds "Revenue" and "B4:T64". It works the same if the range of
cells are named.
This works fine for Charts embedded in a worksheets but if a Chart is on a
Chartsheet I don't have a range or name to reference. I thought it was just
Chart1, Chart2, etc. but that doesn't seem to work.
Thanks!
that is then copied to PowerPoint Slides.
For example: If a Chart is on a Sheet named "Revenue" and in cells B4:T64,
the user just adds "Revenue" and "B4:T64". It works the same if the range of
cells are named.
This works fine for Charts embedded in a worksheets but if a Chart is on a
Chartsheet I don't have a range or name to reference. I thought it was just
Chart1, Chart2, etc. but that doesn't seem to work.
Thanks!