Power Automate Desktop is a Microsoft tool for automating processes in a desktop environment. It’s a really powerful tool, but suffers from one significant drawback… it has limited Excel actions. However, Microsoft has given us the ability to run Excel macros from Power Automate Desktop; therefore, this gives us the power to do almost anything Read More
Category: VBA
How To Create Sheets For Each Item In PivotTable Field
Some Excel features hide in plain sight. They are there, but nobody thinks to click the button. In this post, we are covering one of those features. We are looking at how to create separate sheets for each item in a PivotTable field with the Show Report Filter Pages feature. Excel users love PivotTables because Read More
How to run any macro from one button (magic macro)
Normally, we build user interfaces so that one button runs one macro. But what if we want the user to select which macro to run? How can we handle that scenario? Well, that’s what we are looking at in this post, how to run any macro from one button. Yes, you heard me. One button Read More
Browse for file path with VBA: insert value into cell
In this post, we look at how to browse for file path with VBA, and then insert the selected filepath into a cell. This post is inspired by a question I received: “If you would want to add a browse button right beside the cell that contains the file path so that you won’t need Read More
VBA Rename File (How to + 5 code examples)
VBA in Excel does not restrict us to just a single application. VBA gives us access to the windows environment too. With this we can perform a lot of common file-based actions. One of the most common is to rename a file. In this post, we will look at 5 examples of renaming files with Read More
Application.CutCopyMode = False (How to use it)
If you use copy and paste while recording a Macro, we will see the code which refers to Application.CutCopyMode = False. You may wonder why it’s there? What does it do? In this post, we answer all your question about Application.CutCopyMode. Application.CutCopyMode = False in recorded macros If we record a VBA Macro where we copy Read More
How to install or uninstall Excel Add-ins (Windows & Mac)
An Excel Add-in is a mini-software application that provides Excel with enhanced functionality and automation features. Whilst they can be created by third-party suppliers, even Microsoft themselves develop add-ins to provide additional functionality. Add-ins can take a number of forms: Excel Add-ins – typically these are Excel files saved with .xlam or .xla file types. They can Read More
How to run a macro from a macro (from another workbook)
In VBA, there are several ways to run a macro from a macro, and even run a macro from another workbook. On forums, these methods are used interchangeably depending on the commenter’s personal preferences. This can lead to confusion for anybody trying to learn VBA. Depending on the method for running/calling the macro, the syntax is slightly Read More
How to resize Excel sheet – 4 ways: manual & automatic
This post looks at how to Resize an Excel sheet. It’s a common requirement for users and is especially useful when creating dashboards for different-size monitors. Every office I have ever worked in has been an equipment battleground. It didn’t matter what the equipment was; it just had to be better than everybody else. A new keyboard, Read More
How to close VBA UserForm: Hide vs Unload
VBA UserForms are a key tool for managing user interactions. When UserForms are well designed, they guide users through the options and settings without any help file or guidance. However, from my own UserForm development, I know one of the most overlooked aspects is how to close VBA UserForms. Is it best to hide or unload the Read More