View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scooter Scooter is offline
external usenet poster
 
Posts: 43
Default replace text with a loop

If I wanted to replace text "A3" with "A4" I would do this

Cells.Replace What:="A3", _
Replacement:="A4", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False, _
SearchFormat:=False, _
ReplaceFormat:=False

How could I put this in a loop to also replace also "B3" with "B4", "C3"
with "C4", all the way to "Z3" with "Z4"?