How to select column by header

Is there a simple way to select a column based on a text string in the header row?

Thanks,
Jim

Do you mean locate the text in the header and then select the column where you find the text?

Sorry for not being clear. I want to find then select the entire colum that has a particular name in row 1. The column may not be in the same place (A to ZZ) in different workbooks, but it will always have the same header name.

I want to select specific named columns to perform operations. It may be to copy to another worksheet or to delete based on the header name.

Use this code considering that your header is in row 1.

Please Login or Register  to view this content.

The output will come as a number.