Copying a variable size table from Excel via VBA

-=bb=- · #1 05-29-2013, 08:29 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a table for a variable number of rows	OllieOnline	Mail Merge	1	03-27-2013 02:48 PM
Using macro to add variable number of rows to a protected word table	Julia	Word Tables	1	01-09-2013 06:04 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM
Copying table styles	Ulodesk	Word	1	09-13-2011 03:31 PM
copying a table	Gunfighter	Word Tables	1	05-31-2011 03:34 PM