B
Beebolbod
The code below inserts loads of incorrect values all over the place, rather
than in the hoped for areas. any ideas? I'm trying to search and replace
values typed into cells which reference another sheet. E.G. replace contents
of variable1 with say contents of C1 (typed in sheet 1) but also replace
variable 1 found on say sheet 3.
Here's what i have...
With Sheets("Sheet1")
.Cells.Replace Sheets("Sheet2").Range("c6"), .Range("a6"),
LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
End With
many thanks
Rob
than in the hoped for areas. any ideas? I'm trying to search and replace
values typed into cells which reference another sheet. E.G. replace contents
of variable1 with say contents of C1 (typed in sheet 1) but also replace
variable 1 found on say sheet 3.
Here's what i have...
With Sheets("Sheet1")
.Cells.Replace Sheets("Sheet2").Range("c6"), .Range("a6"),
LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
End With
many thanks
Rob