This video is said to be a year or so old but I just ran across in the UA-cam feed. Template is a good approach but requires some "tricky" navigation. I find Autocorrect to be easier. (Avoid Name Manager completely.) Open the Replace/With dialog box. "Replace" is the short function abbreviation; "With" is the function (a LAMBDA or any functioin). This is available in all workbooks/sheets.
Usefull on both tips, thanks
Nice. How could you bring the template lambda's into an existing Excel file?
Nice & Neat Approach, Thanks for Sharing
And thanks for the bonus tip 🤓
Thanks. Glad you like it. 😀
This video is said to be a year or so old but I just ran across in the UA-cam feed. Template is a good approach but requires some "tricky" navigation. I find Autocorrect to be easier. (Avoid Name Manager completely.) Open the Replace/With dialog box. "Replace" is the short function abbreviation; "With" is the function (a LAMBDA or any functioin). This is available in all workbooks/sheets.
Thanks for the comment and for the alternate solution.
@richardhay645. That's a really interesting approach, but what if the formula contains a cell reference?