I pull data from an online database and when I export it to an excel file, the named ranges change sometimes (I'm not sure why). So I want to create a check to see if these named ranges changed from the previous report to the current one.
How would I pull out the name of the named range out of this? I want it to return [Distance Spreading (miles)], not whats actually in that cell (28.1).
Thank you very much for your help!
