problem with replace (VB)

[Sieto Verver]

Dear all,
Sorry to bother you with this question but if anybody can provide help, it
would be much appreciated.
As a part of a macro code I want to replace values in column E. As the
number of records differs by sheet, I want to select the whole column and
perform the replace action.
With the code below this text, the search and replace is ok, except that the
action is performed within the whole sheet. What is wrong with the
selection?
Hope it is clear.

Thanks,
Sieto

Sub replace()
Columns("E:E").Select
Range("E2").Activate
Selection.Replace What:="AT", Replacement:="anything", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False
End Sub

 

[R.VENKATARAMAN]

try this slight modification

with columns("e:e")
..replace what:="AT",replacement:="anything"
end with

then I thin replcement wil be done only in column E
============

 

[Sieto Verver]

Thanks R. That did the trick, although I don't understand why the other
won;t work, but that's fine for now!

Sieto

 

[Tom Ogilvy]

While I advise the suggested correction as better coding practice, for
interest, your original code ran fine for me.