You can view the page at http://www.excelguru.ca/forums/conte...ironment-Names
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Is there a version of this that works with Excel 2016 64-bit? I copied the VBA code, but even the test case of =GetName("Windows") returns a #VALUE result.
I'm not a VBA guy, so I don't really know what would need changed.
Thanks, in advance.