Accessing Values from Names Manager

Mackeral · Sep 20th 2017

This old code doesn't work with the "Names Manager" any more

Quote

TS = Names("Name_to_Lookup").Value

Now what I get is the "refersTo" information.

How do you extract the "Value" portion in Excel 2016?

At this point I have spent so much time converting code that I wish I'd never switched from 2007. 2016 is so much slower to start. Don't switch!

jaslake · Sep 20th 2017

Re: Accessing Values from Names Manager

Hi Mackeral...

Perhaps

Quote

TS = Range("Name_to_Lookup").Value

TheGlovner · Sep 21st 2017

Re: Accessing Values from Names Manager

I use 2010 in the office and that would produce the same issue you are having.

I'd always use Range as opposed to Name (unless I'm actually manipulating the named range on the sheet in some way).

**Krishnakumar** · Sep 22nd 2017

Re: Accessing Values from Names Manager

or

TS = [Name_to_Lookup]

Note: It won't work if ActiveWorkbook is not ThisWorkbook

Mackeral · Sep 23rd 2017

Re: Accessing Values from Names Manager

Solution:

Code

Names_Get = Names(Name_To_Get).Value

Mackeral · Sep 23rd 2017

Solved: Accessing Values from Names Manager

Solved

Code

Solution = Names(Name_To_Get).Value

Mac

Participate now!