Find/Replace for multiple values at once

[Jl23]

I'm looking for a simple find and replace but for multiple values at once. I know I could just use the find/replace function in Excel but I am changing the same 3 values in over a hundred workbooks so thought a macro would be faster. (Though at this point I've probably spent more time trying to figure it out than if I just did it manually, lol). My values to replace are always in Column A, AC & AE, last row with data varies. My changes are always:

-In Column A change True to False
-In Coumns AC & AE change No to False

Bonus if the macro could also delete the first 2 rows as well

Any help would be greatly appreciated!! Thank you!!

 

[mumps]

Try:

Sub ReplaceValues()
    Application.ScreenUpdating = False
    Columns("A").Replace "True", "False", xlWhole, , False
    Columns("AC").Replace "No", "False", xlWhole, , False
    Columns("AE").Replace "No", "False", xlWhole, , False
    Rows("1:2").Delete
    Application.ScreenUpdating = True
End Sub

 

[Jl23]

That worked perfectly!! Thank you!!!

 

[kvsrinivasamurthy]

Post deleted

 

[mumps]

You are very welcome.