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!