This one should be easy.
In VBA, what would be the proper syntax that would concatenate a quotation mark, a variable, and another quotation mark?
In my line of code:
returns E67.
Please Login or Register to view this content.
However, I want strFirstColorBarCell to evaluate as "E67", so I'd like to pass quotation marks before and after the part of the code that generates E67.
Thanks!
g
try:If I understand what you want.Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Thanks, Solus. That did the trick.
The quadruple quotation mark was the syntax that I needed.
(I had tried to "quote-the-quotes" with three quotation marks in a row, but that is not the way to do it -- four quotes it is.)
I think its one of those weird VBA constants. Four quotes is read as 1. I'm sure they have perfectly good reason for making it that way but I don't know what it is.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks