Find Column Header and Format

[bmkelly]

Hello,

I am trying to update a former analysts VBA code and have it look for specific Column Headers and then Format those Columns.

It seems the code is a record macro of

    Range("P:P,S:S,Z:Z,AA:AA").Select
    Selection.Style = "Good"
    Columns("T:Y").Select
    Selection.Style = "Input"

I would like for this code to look for headers (all in row 1) - Price (P), Analyst Notes (S). Transaction Date (Z) and Transaction Type (AA) and select those column and format to Selection.Style = "Good". Then I would like for it to look for headers - Analyst Notes 2 (T), Vendor Notes (U), FRP/Historical Difference (V), FRP and Historical (W), Coverage Notes (X) and Transfer Notes (Y) and format to Selection.Style = "Input"

Thank you!

 

[bmkelly]

Solved

 

[Fluff]

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.