| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and Replace help
Can someone tell me what's wrong with my code? I am trying to search/replace
several text strings with one macro. Is this possible? Columns("S:S", "BA:BA").Select Selection.Replace What:="accuracy", Replacement:="accuracy1" Selection.Replace What:="XS_EXOFF", Replacement:="XS_EXOFF1" xlPart , SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Thanks- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search and Replace help
Try this...
Union(Range("S:S"), Range("BA:BA")).Select Selection.Replace What:="accuracy", Replacement:="accuracy1" Selection.Replace What:="XS_EXOFF", Replacement:="XS_EXOFF1" HTH "hodeware" wrote: Can someone tell me what's wrong with my code? I am trying to search/replace several text strings with one macro. Is this possible? Columns("S:S", "BA:BA").Select Selection.Replace What:="accuracy", Replacement:="accuracy1" Selection.Replace What:="XS_EXOFF", Replacement:="XS_EXOFF1" xlPart , SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Thanks- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search and Replace | Excel Worksheet Functions | |||
| Search and Replace | Excel Discussion (Misc queries) | |||
| Search and Replace | New Users to Excel | |||
| Search and Replace... | Excel Programming | |||
| Search and Replace... | Excel Programming | |||
Hybrid Mode
