Hello,
I tried to use vba to perform find and replace for the first 2 columns
of a few sheets
say the column F1

Sheets(2).Range("F1").Select
Selection.Replace what:=" ", Replacement:="_", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False

But in the end, all of the cells are processed.
I'd like to know how should I limit the find and replace range
properly?


--
level3
------------------------------------------------------------------------
level3's Profile: http://www.excelforum.com/member.php...o&userid=34541
View this thread: http://www.excelforum.com/showthread...hreadid=543036