T
travis
The following code snippet will replace TextToReplace with
ReplacementText in an Excel worksheet:
Cells.Replace What:=TextToReplace, Replacement:=ReplacementText,
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False
That's easy enough. I'm a little stumped by this next one though...
I want to replace the text in the cell TO THE LEFT of the cell
containing the string TextToReplace with something else, which I'll
call TextDescription.
How do I replace text in the cell NEXT to a cell containing a
particular string?
Travis
ReplacementText in an Excel worksheet:
Cells.Replace What:=TextToReplace, Replacement:=ReplacementText,
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False
That's easy enough. I'm a little stumped by this next one though...
I want to replace the text in the cell TO THE LEFT of the cell
containing the string TextToReplace with something else, which I'll
call TextDescription.
How do I replace text in the cell NEXT to a cell containing a
particular string?
Travis