If it is not a range that the name refers to, you cannot use a range object.

Access it via the RefersTo property

Debug.Print Activeworkbook.Names("PlanDate1").RefersTo

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Barb Reinhardt" wrote in message
...
Bob,

This is not a range name that's tied to a range on any sheet. It's a
constant that's got a range name. I suspect that might make a
difference.
Any suggestions?

Barb

"Bob Phillips" wrote:

Are you on the same sheet? Maybe try qualifying with the sheet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Barb Reinhardt" wrote in
message
...
I have the following code:

Debug.Print ActiveCell.Offset(0, 1).Value
sRangeName = "PlanYear" & ActiveCell.Offset(0, 1).Value
Debug.Print sRangeName
Debug.Print "Range Value = ", Range(sRangeName).Value


ActiveCell.Offset(0,1).value = 1
the range name "PlanYear1" has a value of zero right now. The
definition
shows

=0

at this point in time.

AWS is the activesheet.
sRangeName is a string.

WHAT am I missing?

Thanks