Announcing LAMBDAs to Production and Advanced Formula Environment, A Microsoft Garage Project

cool2021  I want to follow up on PeterBartholomew1  comment on using Lambda vs VBA because I have a slightly different viewpoint.  I actually question whether Lambda will be more efficient than VBA in all cases and believe it will very much depend on the case.  If the formula needs constant updating based on new entries I definitely bet on Lambda but if it is more of a one-time or very in frequent thing (e.g. you would use a button to activate the VBA)  I think you would have to dig further into the code.  BUT all that set aside I go with Lambda over VBA because of compatibility.  VBA is not allowed in the web version and desktop at least on default will block it.  I just think if it can be done with a Lambda instead of VBA it will save you grief down the line to go that way.