Get column number by header name

[ArrayON_56]

I'm new to VBA Excel programming.
I have a table with several headers and I would want to get absolute column number of some header.
To be more clear. There is a form to which user should enter header name (practically header cell content) and the program should get absolute column number where the header is placed in sheet. The column number will be parsed to next code which already exists.
Is there some simple way how to do it, or I have to cycle through each and check if cell(header) content equals to phrase I'm searching for?
Thanks.

PS: I was able to get only here: ActiveSheet.ListObjects("TranslationDataTable").ListColumns("<Some-Header-Name-Here>"), but it only returns content of the cell, and that is practically header name. TranslationDataTable is name of the table I'm searching in.

 

[Marc L]

​

You could use the MATCH worksheet function …​

 

[Alex Blakenburg]

I don’t have my computer in front of me but try adding “.Index” without quotes to the end of your ListColumns statement.
ActiveSheet.ListObjects("TranslationDataTable").ListColumns(“Some-Header-Name-Here").Index
Assuming you mean position in the table not the column number in the sheet

 

[ArrayON_56]

Thanks for answers.
Yes, I mean column number in sheet, but since the table will always start at 1;1, adding .index will work for me.

 

[Alex Blakenburg]

Thanks for answers.
Yes, I mean column number in sheet, but since the table will always start at 1;1, adding .index will work for me.

If you are wanting to return the column number in the sheet you are better off using ".Range.Column" instead of ".Index"
eg
ActiveSheet.ListObjects("TranslationDataTable").ListColumns(“Some-Header-Name-Here").Range.Column