View Single Post
 
Old 07-21-2015, 05:43 AM
LouterMattheus LouterMattheus is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jul 2015
Posts: 1
LouterMattheus is on a distinguished road
Default VBA: Selecting columns from multiple tables

Hi,

In one sheet, I have four tables. And of those 4 tables I want the first columns to be copied to one column in another sheet. If I use record macro and select one of these columns from one table it appears as:

Range("Table1[Meeting]").Select

However if I select all of the specified columns in all 4 tables I get:

Range("B6:B13,B18:B24,B29:B41,B46:B53").Select

I've tried writing:

Range("Table1[Meeting],Table2[Meeting],Table3[Meeting],Table4[Meeting]").Select

However that does not work. How would I get the result I am looking for?

Thank you!
Reply With Quote