Hi all,

Named range = TheYear on a sheet named Master.
On a different sheet:

If I enter in the formula bar in cell (1, 7) =TheYear, I get in cell(1, 7) "=TheYear"

If enter the same info in some random cell I get 2012, I've tried changing the format of cells but it
has no effect. I can't seem to find a pattern to the cells it works in.

thanks,