| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Cell.Replace
Is there any way to make the What:="" be a variable? So if the variable =
Test then the replace code would look for Test. Cells.Replace What:="", Replacement:="", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Cell.Replace
x = Test
sh.Cells.Replace(What:=x,.... Don't use quote marks on variables. "ordnance1" wrote in message ... Is there any way to make the What:="" be a variable? So if the variable = Test then the replace code would look for Test. Cells.Replace What:="", Replacement:="", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| Find & Replace one cell w/another cell unequal occurrences | Excel Discussion (Misc queries) | |||
| Replace cell formula with revised text as noted within a cell valu | Excel Programming | |||
| Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
| Excel - create button to replace cell content with cell value | Excel Worksheet Functions | |||
![ordnance1[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
