Columns Select issue

[BigNorton]

A simple issue that I'm stuck on -- recording a macro -- select column A followed by doing a replace function. When the macro is ran the entire sheet is selected and any occurrence is changed in all columns.

Columns("A:A").Select
Selection.Replace What:="N", Replacement:="NOT FOUND", LookAt:=xlWhole _
, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

Thanks

 

[SkipVought]

hi,

This changes only data in column A

Columns("A:A").Replace What:="N", Replacement:="NOT FOUND", LookAt:=xlWhole _
        , SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}