Making a variable name within a for loop

[gareth001]

Hi,

I've created 6 variables, TargetNo1 through to TargetNo6. When I run the For loop I need it to use the counter in the loop and concatenate it with "Target" so I can then run an If statement on the values held TargetNo1 to TargetNo6.

The VBA I'm using is as follows:

  For intLabel = 1 To 6
    Target = ("TargetNo" & intLabel)
    If Target = 0 Then
        intLabel = intLabel + 1

But Target holds the text string of "TargetNo1" not the value of the variable.

Thanks for you help in advance

Gareth

 

[PHV]

Why not using an array ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244