__Code__

__Rate__

Code 1 Rate 1

Code 2 Rate 1

Code 3 Rate 2

Code 4 Rate 2

Code 5 Rate 1

Code 6 Rate 1

Code 7 Rate 2

Code 8 Rate 1

Code 9 Rate 1

Code 10 Rate 1

I have a string Variable that I set equal to all of the codes that should be assigned rate 1 and another variable of all the codes that should be assigned rate 2, using double quotes around the names and commas to separate them.

The results would look like:

Variable1 = "Code 1", "Code 2", Code 5", "Code 6", Code 8", "Code 9", "Code 10"

Variable2 = "Code 3", "Code 4", Code 7"

Later, I try to do a Select Case statement using the variables to then assign the rates as the loop moves through the rows.

Select Case ActiveCell.Offset(0, 5)

Case Variable1

ActiveCell.Value = Rate 1

Case Variable 2

ActiveCell.Value = Rate 2

It doesn't seem to recognize the strings Variable1 & Variable2 in assigning the cases. Any thoughts?