Array Concatenate text and variable

Question

I would like to create an array as follows:

Dim vHdr As Variant

vHdr = Array("Jogo", "Sala", "Operadora", "Semana", "NSemana", "Acumulado Semana 3")

However, in "Acumulado Semana 3", the 3 is a variable called semana_atual.

I tried:

vHdr = Array("Jogo", "Sala", "Operadora", "Semana", "NSemana", ""Acumulado & "" - "" & " & semana_atual")

but it didn't work.

You should tag your question with what this actually is (i.e. what tool or language). — timss
– timss, Commented May 2, 2013 at 14:45

Kazimierz Jawor · Accepted Answer · 2013-05-02 14:50:57Z

1

What if you try this (for VBA):

vHdr = Array("Jogo", "Sala", "Operadora", "Semana", "NSemana", "Acumulado Semana " & semana_atual)

just you need some order with your quotation marks. (I added 'Semana' referring to what you need, not what you have tried).

answered May 2, 2013 at 14:50

Kazimierz Jawor

19.1k7 gold badges38 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1