Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's wrong here?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
i did something wrong | Excel Discussion (Misc queries) | |||
What am I doing wrong? | Excel Programming | |||
Where am I going wrong? | Excel Discussion (Misc queries) | |||
Where am I going wrong with this? | Excel Programming |