Selecting multiple columns (not adjacent to each other) in a table using column names

[excelguru123]

Hi all, I have a table with multiple columns and I am trying to select multiple columns using their names. Columns aren't necessarily adjacent to each other so I want to use column names to select them. Here is a code:

With wbMyWorkbook.Sheets("Sheet1").ListObjects("Table1")
.ListColumns("Name").Range.Select
.ListColumns("Address").Range.Select
.ListColumns("City").Range.Select
End With

Using this works but it doesn't select ALL of the columns "Name", "Address", & "City". Instead, it will select one column at a time. This is just 3 columns as an example but I have around 15 columns I want selected. To make it cleaner I tried to use an array in .ListColumns() but it takes a single object only. How can I make this work? Thanks in advance.

 

[Sequoyah]

Hi @excelguru123

see @Akuini's answer in this thread

Select Multiple Table columns by header name (vba)

Can someone please give me an example of how to select random table columns based on header name? I tried using Array, but I don't think that is the right thing to use as they are random. I don't want to reference column numbers or letters. Thanks, SS What I have below is where I am. I would...

www.mrexcel.com

 

[excelguru123]

Hi @excelguru123

see @Akuini's answer in this thread

Select Multiple Table columns by header name (vba)

Can someone please give me an example of how to select random table columns based on header name? I tried using Array, but I don't think that is the right thing to use as they are random. I don't want to reference column numbers or letters. Thanks, SS What I have below is where I am. I would...

www.mrexcel.com

Thanks a lot. That's exactly what I was looking for.