Named Constants w/ VBA

[GRCArizona]

Hi -

I've created a Name using the 'Name Manager' and called it 'User'. The name is a Named Constant, so it doesn't refer to a range on the spreadsheet. In the 'Refers To' dialog box it has:

="GRC"

When I try to refer to this in VBA, I would expect to get

GRC

but what I'm getting is:

="GRC"

Here is the code I'm using:

Dim sUser as String
sUser = ThisWorkbook.Names("User").RefersTo​

Anyone know how to get rid of the equals sign (=) and the quotations ("")?

 

[pgc01]

Hi

The RefersTo property of the Name object gives you the definition of the object. In this case what you want is what it evaluates to.

Try:

sUser = Evaluate("user")

or its shorhand

sUser = [user]

 

[GRCArizona]

Perfect. thx!

 

[pgc01]

You're welcome. Thanks for the feedback.