Greetings,
I've written a macro that creates PowerPoint charts from data in an Excel workbook.
It is nearly functional, except for a
failed error message.
The macro is run in a PowerPoint instance with no slides. It creates the correct PowerPoint chart with the data from the first Excel workbook sheet, but fails at this line
when it gets to the second sheet in the Excel workbook. Specifically it says method
when I hover over the line in the VBA editor. Also,
and
still refer to the 1st worksheets data range.
This leads me to believe that my:
References are not properly cycling through to the next sheet in the Excel workbook. This is weird because when I use a static range such as in
, the macro goes through the sheets as it should.
I greatly appreciate any help. My full macro is below:
Bookmarks