Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why does cell.replace work with byrows and not with bycolumns
Hi,
I have a macro where I want to replace a certain string with another string. However, when I put in the macro Cells.Replace What:="(1 markets)", Replacement:="(1 market)", LookAt:= _ xlPart, SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False it does nothing, but if I change SearchOrder:=xlByColumns to SearchOrder:=xlByRows, then it works fine. Can anyone explain why? If it helps, the cells in which the strings to be replaced can be found are all in 3 cells merged together, with the string in the left most of the 3 cells (all 3 cells are on the same row). Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
why does cell.replace work with byrows and not with bycolumns
Merged cells are a pain.
There are somethings that work with merged cells and some (lots???) of things that don't. You may want to consider yourself lucky since you do have an alternative. ps. I tested in xl2003. But each version of excel seems to treat merged cells a little better. Maybe it works in xl2007 or will work in xl2010???? chris12345 wrote: Hi, I have a macro where I want to replace a certain string with another string. However, when I put in the macro Cells.Replace What:="(1 markets)", Replacement:="(1 market)", LookAt:= _ xlPart, SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False it does nothing, but if I change SearchOrder:=xlByColumns to SearchOrder:=xlByRows, then it works fine. Can anyone explain why? If it helps, the cells in which the strings to be replaced can be found are all in 3 cells merged together, with the string in the left most of the 3 cells (all 3 cells are on the same row). Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace in ranges does not work. | Excel Programming | |||
Limited byrows propagate a value via macro to all cells in column | Excel Worksheet Functions | |||
find and replace does not work in a linked cell | Excel Discussion (Misc queries) | |||
Does "find and replace" work within a chart? | Charts and Charting in Excel | |||
Replace a sheetname with a cell reference to link to another work. | Excel Worksheet Functions |