This old code doesn't work with the "Names Manager" any more
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!