View Single Post
 
Old 07-22-2015, 06:33 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

I could be wrong, but it's my belief tables can only be worked with like that on an individual basis.
This would be why with your selection from one table only, Excel used the table and column names, and when the selection was from multiple tables Excel ignored the tables and used ranges.
To use the table and column names to do the copying, I think you'll need to loop through the tables on the sheet and do it one at a time.

A couple of links to pages dealing with tables that may interest you
http://www.jkp-ads.com/Articles/Excel2007TablesVBA.asp
http://www.thespreadsheetguru.com/bl...t-excel-tables
Reply With Quote