How to concatenate an integer to a variable

[Brad24]

Hi, I have a variable that I need to keep adding a number to in a for loop.

So I want Temp1=value and then Temp2=value and then Temp3=value

How would I go about something like that?

I tried things like "Temp" & i

Temp & i

but I'm on the wrong track....ugh

 

[djrod1rep]

Hi Brad24, which scenario are you trying to accomplish:

1. Adding values to get a FINAL result. Meaning: 2 + 2 + 2 = 6 (final value)
2. Adding values to get a FINAL number. Meaning: 2 + 2 + 2 = 222 (final number)

Please advise.

 

[Norie]

I'm sorry but you can't use that syntax to refer to variables.

If you do have multiple variables Temp1, Temp2 etc have you considered an array?

Dim Temps(1 To 10)

   Temps(1) = 10
   Temps(2) = 20
   ' etc

 

[Brad24]

Ok, thanks. I will rethink what I'm doing. Thanks