Forum Discussion
Despair over external references to local scope Lambdas
There must be something weird about local scope Lambdas. As far as I can tell, they are a perfectly valid concept. On a noddy level, they also work as advertised. But eg the developers behind AFE ...
SergeiBaklanHere you go. Try it for yourself. Open Book2 and Book1. Book2 does nothing other than to provide the local Lambda myFunc. You will see that Book1 tries to call myFunc but returns #NAME! because the reference is invalid. Fix it. Save Book1. Close it. Re-open. Bang - f***ed again.
SergeiBaklanCorrection. The error in Book1 is more fundamental - it refers to the wrong Workbook. When I correct this, the little setup is unfortunately unable to reproduce the problem.