Most of the time that you are working in Excel, you will be working with ranges. And working with ranges in Office Script is very different than working with ranges in Visual Basic for Applications! Using a very simple macro, …
Category: office script
Recording an Office Script in Excel Online
The newest form of automation in Excel is Office Script; this uses the power of TypeScript and the web to automate spreadsheets! In this post, we’ll be recording an Office Script using the script recorder. This recorder provides an easy …
VBA in 2020 – Where does it fit?
Since 1993, Visual Basic for Applications has been the first choice for Excel automation. As a programming language that was available for business users, millions of macros have been created in VBA. But, is VBA still relevant in 2020? Popularity …