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!
|