| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add "'" into string?
Within macro, I would like to replace "1'" with varable + "', there is an
error. Please see the following code for details Cells.Replace What:="1'", Replacement:=Range("A2").Value&"'", LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False Does anyone have any suggestions on how to solve this coding? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | Excel Worksheet Functions | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
| Converting string "061123" into a date "23/11/06" | Excel Programming | |||
| Making "examp le" become "examp_le" in a string | Excel Programming | |||
Threaded Mode
