vba - Array Concatenate text and variable -
i create array follows:
dim vhdr variant vhdr = array("jogo", "sala", "operadora", "semana", "nsemana", "acumulado semana 3")
however, in "acumulado semana 3", 3 variable called semana_atual.
i tried:
vhdr = array("jogo", "sala", "operadora", "semana", "nsemana", ""acumulado & "" - "" & " & semana_atual")
but didn't work.
what if try (for vba):
vhdr = array("jogo", "sala", "operadora", "semana", "nsemana", "acumulado semana " & semana_atual)
just need order quotation marks. (i added 'semana' referring need, not have tried).
Comments
Post a Comment