Adding a numeric value to a Name Object

[JohnM3]

Hi

My first post so I am not air tight on rules and posting tags but its
a straight-forward question.

    '------------------
    '   Add Names
    '------------------
    With WB_This
        .Names.Add "FCST_QTRS", RefersTo:=4
        .Names.Add "FCST_WKS_QTR", RefersTo:=13
        .Names.Add "FCST_WKS", [FCST_QTRS*FCST_WKS_QTR]
        '.Names.Add "FCST_WKS_Test", MyEval_Names("nForecast_Qtrs", "nForecast_Wks_Per_Qtr")
    End With

    a = [FCST_QTRS]
    aa = Names("FCST_QTRS").Value

    MsgBox a
    MsgBox aa

    b = [FCST_WKS]
    bb = Names("FCST_WKS").Value

    MsgBox b
    MsgBox bb

Goal:I want the variable value aa to be 4 (if possible)

Question:

I thought that

aa = Names("FCST_QTRS").Value

would return 4. But (as coded) it returns =4

OTOH -

a = [FCST_WKS]

returns 4 and [] indicates (guessing) an evaluate is going on.

My question(s)

Have I miscoded the Name definition?

OR

Am I using the wrong Name property to get to the value 4 and not
the =4 answer I am seeing

OR

something else I am just not understanding.

regards
John

 

[shg]

You're using it properly, and the brackets are a shortcut the the Evaluate function as you surmised.

 

[JohnM3]

You're using it properly, and the brackets are a shortcut the the Evaluate function as you surmised.

Thank you.

regards
John

 

[shg]

You're welcome, good luck.