find and replace only within selection

[frustrated_macro]

So i have data in columns A and B which are exact. im trying to replace the text JUST in column A from X to Z and i thought it had been working but i just realized its grabbing the text in column B and replacing it too.

I cant have it replace what is in B because that is the true final text. im just using column A text to group categories together to later use the FILTER function



what am i doing wrong?



Columns("A:A").Select

Selection.Replace What:="Example Text", Replacement:="AS & TNT", LookAt _

:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

 

[6StringJazzer]

When I run your code it only replaces the text "Example Text" in column A. The same text in other columns is untouched. Please show all of your code.

column A from X to Z

What does this mean?

 

[Alex Blakenburg]

I agree with Jeff @6StringJazzer that it works as you are intending.
Is there any chance that you have a formula in Column B that is bringing in the value from Column A, so that the change in A if flowing through ?

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: find and replace only within selection - OzGrid Free Excel/VBA Help Forum
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.