Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Escape for special characters in string
I want to be able to put:
.InsertLines StartLine, " sheetName = ActiveSheet.name & "sheetName"" to generate the code section of a button click procedure. The problem is the embeded double quote. In C/C++ one would write the embedded double quote as \", i.e., the \ "escapes" the string interpretation to treat the followin character literally. Is there such a concept in VBA? I've tried putting Chr(42) but this does not generate the wanted code. Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
special Characters | Excel Discussion (Misc queries) | |||
Special characters | Excel Discussion (Misc queries) | |||
special characters | Excel Worksheet Functions | |||
Special characters | Excel Worksheet Functions |