Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Replacement
Hi I want to replace NameY (fixed) with NameX, but name X change for every sheet. So my intetion is to relate it to the contain in cell J2 that is different at different sheet. I have this code now but as I have told you i want to relate it to the contain in cell J2. Sub ReplaceName() ' Cells.Replace What:="NameY", *Replacement:="NameX", * LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub Thanks Rune -- mowen ------------------------------------------------------------------------ mowen's Profile: http://www.excelforum.com/member.php...fo&userid=8463 View this thread: http://www.excelforum.com/showthread...hreadid=465486 |
#2
|
|||
|
|||
Try this:
Replacement:=Range("j2").Value ....between your stars, but remove the stars to run the code, of course. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi Replacement | Excel Discussion (Misc queries) | |||
Hyperlink-Programable replacement of Text with Its Actual Address | Excel Worksheet Functions | |||
Global Replacement of Test to Display | Excel Worksheet Functions | |||
How do I set up a equipment replacement reserve schedule | Excel Worksheet Functions | |||
Binder replacement for XP | Excel Discussion (Misc queries) |