Range("B2,c3:c99,d1,e1,f3:f8").value = "Green"

Gets a lot of cells at once.

Jelinek wrote:

I am trying to create a refresh macro that turn a number of cells back to
green.

I no i can do it at a an individual cell (i have pasted the code i have
used) level is there an easier less time consuming way as i have quite a few
cells i need to do this for.

Range("B2").Select
ActiveCell.FormulaR1C1 = "Green"

--

Dave Peterson