Thread: Copying a variable size table from Excel via VBA
View Single Post
 
Old 05-29-2013, 08:29 AM
-=bb=- -=bb=- is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: May 2013
Posts: 8
-=bb=- is on a distinguished road
Default Copying a variable size table from Excel via VBA
Hi everyone,

Not sure if this falls more into the Excel Programming but since I am doing it from PowerPoint, I hope it is OK here.

I want to copy an Excel table, of variable size, into a slide in my presentation. Easy enough to do manually, but I would like to automate the process if at all possible.

I am trying lots of variations but getting no joy at all. Its no problem if I have a table of a known size, I can just

Code:
 
objWbk.worksheets("Exec Summary").Range("G18:H21").Copy
but I am failing quite badly to get it to work with any kind of variable sized table.

Could anybody please point me in the right direction on how to do this?

Many thanks in advance.

bb
Reply With Quote