MS Excel / VBA help thread

You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.

•

aggi

Is it possible to have a recursive LAMBDA function without first defining the LAMBDA formula you want to call in name manager?

I'd like it to be a one line formula that other people could use without having to work out how to import the function but I can't quite see how you'd do that.

•

Chalfie in reply to @aggi

I've never used this

but this https://www.ablebits.com/office-addins-blog/write-recursive-lambda-function-excel/#:~:text=Basically%2C%20a%20recursive%20function%20works,complex%20problems%20with%20no%20coding.

or this
https://www.reddit.com/r/excel/comments/pcnpit/is_it_possible_to_create_anonymous_recursive/

•

aggi in reply to @Chalfie

Cheers. This is definitely the question I was asking which is further than I got in my googling. Now to see if I understand the answer.

About

Avatar for Chalfie @Chalfie started