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