How to re-write the following code line, to refer to columns by headers?

Hi all,

Here is my current code line:

Please Login or Register  to view this content.

cl is referring to cells in the first column, so this code is supposed to join/concatenate the strings in A:C with | in between them..

I would like to rewrite this code line, so instead of A:C it would do column A, C and E? The code refers to a table so a listobject, and if possible, it would be great to refer to the columns by their headers. A: First names, C: Last names, E: Fruits.

Can someone help me with this please?

That still requires me to know the number of the columns, which I would also like to avoid if possible?

Also what is application.index? I have 2016 excel and I couldn't find it in the object browser.

Originally Posted by LIL2606

cl is referring to cells in the first column, so this code is supposed to join/concatenate the strings in A:C with | in between them..

I would like to rewrite this code line, so instead of A:C it would do column A, C and E? The code refers to a table so a listobject, and if possible, it would be great to refer to the columns by their headers. A: First names, C: Last names, E: Fruits.

Try something like

Please Login or Register  to view this content.

Thank you for that! It does the job!