How to ask excel to look for a specific header then do something with the column?

[coralfangs]

for example,
My excel files have several columns with header "test results"
Each sheet has the header in a different column.
for example
sheet 1 has it in B, 2 has it in D, etc
The same goes for every file.
So I want to make a macro that would recognize the header and do something to do. Specfically, I want to select any numbers in the column bigger than 500 and highlight those.

so my question is
How to Range(" ").Select the specific columns with header "test results"

[VBA Noob]

See if this helps

Please Login or Register  to view this content.

VBA Noob