Interesting VBA Question
Posted by Julio on October 26, 2000 3:24 PM
Does anyone know, is it possible to concatenate a
I know it might sound strange to attempt this, but
I feel it would be really convenient; for ex.
Month1 = "Jan"
Month2 = "Feb"
n= Range("c19") -A Range containing the number
result of a ComboBox-
ActualMonth = Month & n
...and here is where I need help...
How do you tell VBA that the result of joining the
two is a variable called Month1 or Month2, and not
Month plus the value of "n"...
I know you can attempt to this with IF's but it's
Anyways, Thanks in advance for all your help!