★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Get the code ★
https://exceloffthegrid.com/reusable-office-scripts/
★ About this video ★
Recently, Office Scripts gained the ability to run scripts using parameters. This means we can provide custom values to change the outcome of the Office Script.
This suddenly makes Office Scripts significantly more useful in Excel.
In this video, we work step-by-step, showing how to change a recorded code into a reusable script that leverages this new feature.
0:00 Introduction
0:30 Outline example
0:55 Recording the action
3:27 Handling errors
6:13 Apply to all
8:22 Apply to all
7:44 Prevent drag and drop
10:44 Sharing scripts
11:35 Quick access
13:24 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
#MsExcel