AFGPHXExcel
asked on
How do I use a comma in a string?
I want to set my string variable, v_WksNamesStr, equal to the value of "Requirements", The code looks like this:
v_WksNamesStr = ""RequirementSummary","
Its looking for more after the comma.
v_WksNamesStr = ""RequirementSummary","
Its looking for more after the comma.
Last Comment
It looks like you had too many doublequotes and a superfluous comma
Not sure if the comma is part of the string but if it is, then you have to do like this:
v_WksNamesStr = "RequirementSummary,"
v_WksNamesStr = "RequirementSummary,"
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Hi, did you notice that that was exactly what I proposed?
Saqib
Saqib
Thanks ModCorlEEone
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Open in new window