VBA code to simulate Excel LET function? use LET before available

Hello, if anyone done VBA to simulate LET function, I appreciate where to find this (free or pay) source code if possible.

https://answers.microsoft.com/en-us/...f-a5ca994a766a

To do LET before it avails, my brain-storm below if you can help guess-estimate following ⒈ man-hours⒉ free resource (e.g. VBA codes)
1. Named-formula (e.g. LETvba ) to contain final code. VBA interpret & run LETvba ; when LET avails, only 1 step away (replace LETvba with its Refers-To) from the final formula. Challenging to troubleshoot when code is in Names. But closer to final product.
2. Helper cell to to contain final code. VBA to convert to LET-less formula for cell ; when LET avails, also only 1 step away (C&P helper to cell). Easier to troubleshoot but need to remove helper
3. Helper Sheet to do item 2 above.
4. Converter Tool for LET-less formulas. This is ideal because I no longer worry about re-coding.

Helper cell to to contain final code. VBA to convert to LET-less formula for cell ; when LET avails, also only 1 step away (C&P helper to cell). Easier to troubleshoot but need to remove helper

sunny123 said:

Hello, if anyone done VBA to simulate LET function, I appreciate where to find this (free or pay) source code if possible.

https://answers.microsoft.com/en-us/...f-a5ca994a766a
Helper cell to to contain final code. VBA to convert to LET-less formula for cell ; when LET avails, also only 1 step away (C&P helper to cell). Easier to troubleshoot but need to remove helper

Hi there

@sunny123

perhaps for those who don't know or haven't understood the LET function -- this explains it :

The New Excel LET Function: How to Use It & Why You'll Love it

I'd assume that any version of EXCEL (alternatives to Ms OFFICE) that doesn't have some sort of "in line coding --e.g VBA type of thing) or abilities to create functions or procedures would be a non starter.

However with earlier versions of Ms EXCEL it might be possible to replicate this -- am looking into the possibilities.

The Define Name function probably is your best bet for this. Not quite 100% the same but near enough.

Create Custom Functions Using Names - MS-Excel Tutorial

Cheers
jimbo