title: Paste a range from Excel into certain slide of Powerpoint Template using VBA
body: <p>I've spent a good few hours looking at various suggested solutions to my problem but cannot find anything that seems to do the job, or more likely, my grasp of VBA is understanding my ability to make sense of the online solutions. As such, I'm hoping one of you kind folk can help me resolve things.</p>
  
  <p>I have an Excel Worksheet open that contains a small amount of data (Headings and numbers etc.)</p>
  
  <p>I want to copy this range and paste it (not as a picture, I want to be able to format it within powerpoint if necessary) on a particular slide (slide 2) in a Powerpoint template I have already created.</p>
  
  <p>My VBA correctly opens up a new presentation based on the template using the following code:</p>
  
  <pre><code>    'Opens a PowerPoint Document from Excel
  
  Dim objPPT As Object
  
  Set objPPT = CreateObject("PowerPoint.Application")
  objPPT.Visible = True
  
  'Change the directory path and file name to the location
  'of your document
  
  objPPT.Presentations.Open "C:\Users\Colin\Dropbox (Edge45)\Edge45 Team Folder\Edge45 Company Documents\Templates\Powerpoint Templates\Edge45 Audit Template Macro.potm", Untitled:=msoTrue
  </code></pre>
  
  <p>However, this is where I get stuck - I don't know how to paste the Excel tabular data into the correct slide once the presentation is open. My data is in range A1:D16</p>
  
  <p>Thank you so much in advance</p>