Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-29-2013, 08:29 AM
-=bb=- -=bb=- is offline Copying a variable size table from Excel via VBA Windows 7 64bit Copying a variable size table from Excel via VBA Office 2010 32bit
Novice
Copying a variable size table from Excel via VBA
 
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
 



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
Copying a variable size table from Excel via VBA Run-time error '91': Object variable or With block variable not set tinfanide Excel Programming 2 06-10-2012 10:17 AM
Copying a variable size table from Excel via VBA Copying table styles Ulodesk Word 1 09-13-2011 03:31 PM
Copying a variable size table from Excel via VBA copying a table Gunfighter Word Tables 1 05-31-2011 03:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft