Hey All,
I am trying copy multiple excel tabs graphs to PPT. Below is the code to select the tab and the range to copy to PPT. But getting a "object required error". Can anyone help?
BPCInputs is the tab name and "b2:r24" is the range in the tab that i want to copy to PPT. I can provided full code if needed but this is where the error occurred.
PasteRng PPPres, 2, (BPCInputs.Range("b2:r24"))
It is always a good idea to include a workbook since it helps to see the issue and test the solution. Sometimes one can get by with code, but rarely with a single line of code.
Attached is how I mass copy ranges and charts to PowerPoint.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks