Hey all,

The code below is extremely repetitive. Basically I'm just trying to create a new slide in PP between each set of dashes ("CAMPAIGN OVERVIEW", "OVERVIEW ANALYTICS"). I'm going to be writing the last two parts ('Add a new slide where we will paste the chart / ' Copy range from excel to current slide) over and over. I tried to create a separate sub-routine to call, which took in sheet name, range, and title as variables, but it failed because it didn't know what "newPowerPoint" was.

I hope it is clear what I'm looking for! Here is the code (incomplete - some other stuff at the end you don't need to worry about):

Please Login or Register  to view this content.