Evaluating a string that represents a variable name

Dim color_positive as integer

color_positive=36  'Light green
Range("a1")="color_positive"

I would like to set the background color of a cell to the value of the variable whose name is in range("a1")

However, neither of the following seem to work.

range("b1").interior.colorindex=range("a1") 

range("b1")interior.colorindex=evaluate(range("a1"))

Welcome to the forum, geko.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.