Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi! For example, in my vba code, I need to assign a string to a variable. For example, I have a string as abc"def. How can I include this " in my string. The one shown below would not work. Please advise. Thanks, Aijun. sMyStr = "abc"def" -- Ai_Jun_Zhang ------------------------------------------------------------------------ Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...o&userid=25474 View this thread: http://www.excelforum.com/showthread...hreadid=392369 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I figured it out. sMyStr = abc""def will do it. -- Ai_Jun_Zhang ------------------------------------------------------------------------ Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...o&userid=25474 View this thread: http://www.excelforum.com/showthread...hreadid=392369 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to read a string in excel and include the single quote | Excel Discussion (Misc queries) | |||
Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
Pivot Table "Include hidden items in totals" | Excel Discussion (Misc queries) | |||
Automatically include contents of a cell in "Save As..." filename. | Excel Programming | |||
How to include a double quotation character in a string? | Excel Programming |