I want to write a macro that replaces part of a string EG
Where the word "AUTHORITY" appears
to replace it with "AUTH"
When I use the code that the macro recorder generated when I used the replace function
on the toolbar it does not replace the word when it is part of a larger string of words. The code that I am using now :
Selection.Replace What:="AUTHORITY", Replacement:="A", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
The word "AUTHORITY" appears in lots of cells but in a larger string as "CHURCH CHARITY + LOCAL AUTHORITY".
How do I write this code so that it replaces the word for me even when it is part of a larger string.