Concatenate "

Visual BASIC 5, VBA
How to concatenate string and retain double quotes inside
///
prestring = "A:" & a
rangestring = " Worksheets("Cheque").Range("" & prstring  &   "")"
Visual Basic is unhappy with this
I want to change range at a runtime
Here is result I want, I want to change number next to A:
Worksheets("Cheque").Range("A:6")
Any help appreciated
///

LVL 1
mativareAsked:
Who is Participating?
 
zsiConnect With a Mentor Commented:
instead of using "", try using chr$(34)

zsi
0
All Courses

From novice to tech pro — start learning today.