Excel 2007 : Replace a text (shares) with (Linked Units)

[PONJO]

Good Day

I have a workbook with with 15 sheets, each sheet has a lot of entries my objective here is to write a macro that will run through each sheet searching for the word "Shares" in every column and replace it with " Linked Units".

your Help is highly appreciated.

My code Below:

Selection.Replace What:="Shares", Replacement:="Linked Units", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

[Cutter]

Why not use the Find/Replace feature. To open the window use Ctrl+H.
Find: Shares
Replace: Linked Units
click Replace All

[PONJO]

The problem is I'll have to go tab-by-tab and perform that function which i find very time consuming since there's a lot of tab in this workbook.

Thanx for the suggestion

[Cutter]

The window retains the values and remains open while switching sheets. You do it for first tab, click on second tab and hit Replace All, click next tab and click Replace All, etc

Doing this for only 15 tabs will be a lot quicker than writing the macro and implementing it.

[PONJO]

Well I guess you right, I’ll stick to the find/replace function. Thanx for the assistance

Take care

[Cutter]

You're welcome. Don't forget to mark your thread as SOLVED (instructions are in rule #9 - click Forum Rules @ top of page to view).