I have 55 charts in Excel that I want to paste into a Word doc. The following code works well for a small number of charts. I’m looking for a way to adjust this code so I don’t have to insert 55 bookmarks in Word and change each iteration of “copy chart/paste chart” to match the Bookmark name with Chart name. I’m thinking I can use an “Until loop” to select, copy and paste until Chart Name =”Chart 55” with a carriage return after each paste. Any advice would be appreciated!
Please Login or Register to view this content.
Bookmarks