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