Getting value from named range that was defined as a formula

[Mary90]

Good day guys!

I'm trying to use a hidden named range to hold the value of a date that I can refer to in my VBA formulae.
So I've created a named range called "ExpiryDate" and it does not refer to a cell, but directly to: "=DATE(2018,12,31)"

So using vba, I'd expect

names("ExpiryDate").refersTo

to be "=DATE(2018,12,31)" and

names("ExpiryDate").value

to be "31 Dec 2018" (or 43465 or whatever date format).
However, it returns the same as the "refersTo" code (including the "=" as the first character)

How can I get the actual date value to be returned so I can set it equal to an integer variable?

Thanks in advance.

 

[Norie]

You could try [ExpiryDate].

 

[Mary90]

You could try [ExpiryDate].

That works! Thanks. But what does this mean when you use the square brackets?

 

[Norie]

It's short hand for Evaluate, so you could also use Evaluate("ExpiryDate") if you want to make things clearer - I was just being lazy.