Hi Gerry

Rather than using 'cells' use 'range'

Worksheets("Data").Range("STATUS").Value = "Running "

HTH
Trevor Williams

"GC" wrote:

How do you use a range name within a formula?
example
I have a range (1 cell) called STATUS.
I would like to use my named range in the following formula.

Worksheets("Data").Cells(23, 1).Value = "Running "

Thanks a bunch,
Gerry