can i set a set dynamic variable?

[Arcticwarrio]

Hi all,

basically i want to set variables dec1 dec2 dec3 etc

something like

For i = 1 To 10
    dec & i = Range("C" & i + 7).Value

except this doesnt work

any ideas?

 

[VoG]

You would need to use an array variable

Dim dec(1 To 10) As Variant
For i = 1 To 10
    dec(i) = Range("C" & i + 7).Value
Next i

 

[Arcticwarrio]

Thanks VoG

:D

Arctic

 

[Arcticwarrio]

is there a right or wrong way to clear them

eg will this cause problems i dont know about?

For i = 1 To 10     dec(i) = "" Next i
Cheers
Arctic.

 

[VoG]

Try

Erase dec