Cell Value to refer to Variable

[SchoolBoyError]

Hi,

I have declared 5 variables: Step1Names, Step2Names, Step3Names, Step4Names and Step5Names. If the cell value is 3 I would like to add the persons name to Step3Names. I tried to do this by writing

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

but it didn't work.

Any suggestions? As you can tell I'm a complete novice!

[6StringJazzer]

It's not clear what you're trying to do. You can't refer to a variable name by building up a string, if that's what you intend for that code to do. The expression on the left side of an "=" must be a variable or range reference, or other object type that you can assign a value to. In your code it's a string. Even if that string is "Step3Names" it won't be treated as the variable Step3Names. They are two different things.

Please post all your code, and use code tags.

[SchoolBoyError]

Thanks, I thought that might be the case so I'll try and use a select case.

Thank you