Dermot

Copying Lambdas between workbooks and keeping them updated

Dermot

Board Regular
Joined
Aug 11, 2006
Messages
140
Office Version
  1. 365
Platform
  1. Windows
Dermot submitted a new Excel article:

Copying Lambdas between workbooks and keeping them updated - Copying Lambdas between workbooks and keeping them updated

Lambdas are held in individual workbooks. How can we copy them between workbooks, and keep them up to date if they change?

Based on the current Excel beta version 2111
* copying any sheet (even blank) from workbook A containing lambdas to another workbook B, will also copy those lambdas to B. The copied sheet can be deleted immediately after copying, ie it does not need to be retained in B.
* if the lambdas already exist in B, Excel will duplicate them, ie the Name Manager will list...

Read more about this Excel article...
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

tboulden

Board Regular
Joined
Jan 14, 2021
Messages
59
Office Version
  1. 365
Platform
  1. Windows
Andy Gordon and Jack Williams from Microsoft Research revealed that the LAMBDA editor add-in they've been working on should be available via the Microsoft Store sometime in the near future. Video should be available here, video should be available under the "ACCESS" section, first session, around hour 10 of the Teams recording. I've gotten to test an earlier version, but what they demo'ed today has syncing with GitHub, which would be helpful in managing LAMBDA versioning.
 

Forum statistics

Threads
1,144,098
Messages
5,722,457
Members
422,436
Latest member
deadlock123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top