[VBA] Variable from Names

[skorpionkz]

Hi guys,

I have Name (let say myName) that I am adding value (let say myValue). This is not the range, I want it to hold the value itself (which is name of another workbook for later use in VBA). In the name manager myName shows correct value, but when in VBA I am trying to assign myName.value to the variable, instead of having "myValue" i am getting "="myValue"", therefore it crashes further code.

Any idea, how to get around it?

Thank you

 

[steve the fish]

Presuming its a single cell named range you need:

Range("myName").Value

 

[RoryA]

You could use Evaluate like this:

Evaluate("myName")

or just:

[myName]

 

[skorpionkz]

You could use Evaluate like this:

Evaluate("myName")

or just:

[myName]

[myName] didn't work, but Evaluate did the trick. I got brain lock and forgot about Evaluate

Thank you.

 

[skorpionkz]

Presuming its a single cell named range you need:

Range("myName").Value

as per initial post, this is not the range, I needed just value.
Sorted already, thank you.

 

[steve the fish]

as per initial post, this is not the range, I needed just value.
Sorted already, thank you.

Sorry i dont know what you mean. Im surprised it doesnt work for you.