Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find & Replace Help
My VBA Code is trying to Find the string 'STABLE' and Replace it with
the string 'STA', searching a VBA-selected variable range. Code snippet follows: Range("E5:X" & (iTotalRecs * 2 + 4)).Select Selection.Replace What:="STABLE", Replacement:="STA", LookAt:=xlWhole, _ SearchOrder:=xlByColumns, MatchCase:=True When I step thru the Code, (current value of iTotalRecs is 1), I can see the specified range of E5:X6 is selected. However, only the 'STABLE' values in Row 5 are replaced. Please help. JingleRock P.S.: I had failed experiments w/ xlPart and w/ xlByRows. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find & Replace Help
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "JingleRock" wrote in message ... My VBA Code is trying to Find the string 'STABLE' and Replace it with the string 'STA', searching a VBA-selected variable range. Code snippet follows: Range("E5:X" & (iTotalRecs * 2 + 4)).Select Selection.Replace What:="STABLE", Replacement:="STA", LookAt:=xlWhole, _ SearchOrder:=xlByColumns, MatchCase:=True When I step thru the Code, (current value of iTotalRecs is 1), I can see the specified range of E5:X6 is selected. However, only the 'STABLE' values in Row 5 are replaced. Please help. JingleRock P.S.: I had failed experiments w/ xlPart and w/ xlByRows. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |