VBA parse cell ref from formula Replace with Header

Hi Friends,

I have some long formulas and I am trying to wrap my head around what they're doing. I'm thinking th best way to handle this moving forward is to somehow parse the cell references from th formulas and replace with th Headers. A Google search reveals a ton of results so I know it's doable. Just haven't found an exact or close match to what I'm looking to do (yet).

I am reaching out to th community because I'm hoping someone has th exact piece of candy I'm looking for and could share a link pointing me in th right direction.

Here's a little taste of th nasties I'm trying to put to bed.

Formula:

Please Login or Register  to view this content.

Thank for any suggestions and for taking th time to read

If you store your data in a table then you can refer to the headers in the formulas quite easily.

BSB

Hi BSB & MarvinR,

I agree with you BSB, but I still have th same problem more or less just converting my data into table wont convert my formulas to listobject references in the formulas. And while you might think it's no BIG deal to do by hand there's +700 columns of deeply nested formulas. lol lots of fun...

I would love to use a table but unfortunately its not a permanent solution right now. In th future but not fight now unfortunately.

But for th sake of getting this done lets make that the scenario, I converted my data to a table. Now I need to convert my formulas to the listobject references.

Again if anyone has a piece of code that does something like that great, or a link.

Thanks,

-B