Forum Discussion

justinmalecha's avatar
justinmalecha
Copper Contributor
Nov 28, 2023

Pulling named range out of formula

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!

Resources