macro Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/macro/ Bestselling Excel and Power BI Courses Tue, 05 Dec 2023 13:28:33 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png macro Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/macro/ 32 32 Excel VSTACK Function – The One Excel Formula to Append Them All https://www.xelplus.com/excel-vstack-function/ Thu, 26 May 2022 23:55:00 +0000 https://www.xelplus.com/?p=9237 This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

The post Excel VSTACK Function – The One Excel Formula to Append Them All appeared first on Xelplus - Leila Gharani.

]]> How to Use Office Scripts with Power Automate https://www.xelplus.com/office-scripts-with-power-automate/ Thu, 12 Aug 2021 08:00:00 +0000 https://www.xelplus.com/?p=9855 Learn to combine Office Scripts with Power Automate so you can run your macros without opening your files. You'll learn how to create a script, how to loop through each sheet in the script and how to setup Power Automate to apply the script to every file in a folder.

The post How to Use Office Scripts with Power Automate appeared first on Xelplus - Leila Gharani.

]]> What’s the Difference Between Excel VBA and Office Scripts https://www.xelplus.com/excel-vba-vs-office-scripts/ Mon, 24 May 2021 11:19:00 +0000 https://www.xelplus.com/?p=10101 What's the difference between Excel VBA macros and Office Scripts? Do you need to switch from VBA to Office Scripts? Find out in this detailed article. I show examples of what you can achieve with VBA and the current status of Office Scripts and explain what each is for.

The post What’s the Difference Between Excel VBA and Office Scripts appeared first on Xelplus - Leila Gharani.

]]> Learn Excel Macros in 10 Minutes https://www.xelplus.com/learn-excel-macros/ Fri, 02 Apr 2021 04:48:00 +0000 https://www.xelplus.com/?p=10171 If you find yourself repeatedly performing the same steps in the same order in Excel, your brain should immediately declare, “I should automate this with an Excel macro!”. You will see that VBA doesn't have to be scary and that you can easily generate VBA code by recording your actions.

The post Learn Excel Macros in 10 Minutes appeared first on Xelplus - Leila Gharani.

]]> How to Create a Custom Progress Bar in Excel with VBA https://www.xelplus.com/excel-vba-progress-bar/ Wed, 15 Apr 2020 09:00:00 +0000 https://www.xelplus.com/?p=11381 A progress bar is a great addition for Excel macros that take long to run. It gives your project a more professional touch. It's also quite easy to add. You can create your progress bar once and reuse it in your Excel VBA projects.

The post How to Create a Custom Progress Bar in Excel with VBA appeared first on Xelplus - Leila Gharani.

]]> How to Find Formulas that use External Links in Excel https://www.xelplus.com/excel-external-links-trick-dynamic-arrays/ Thu, 24 Oct 2019 09:00:00 +0000 https://www.xelplus.com/?p=12045 Get a list of all your external links in your Excel file with a trick that combines the past with the future. This way you can make sure all your links are pointing to the right files.

The post How to Find Formulas that use External Links in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel VBA GetOpenFileName to Browse and Select File https://www.xelplus.com/excel-vba-getopenfilename/ Thu, 26 Sep 2019 09:00:00 +0000 https://www.xelplus.com/?p=12084 You can use Excel VBA GetOpenFileName method to copy data from another Excel file by browsing for and selecting the file from the Open File Dialog Box.

The post How to Use Excel VBA GetOpenFileName to Browse and Select File appeared first on Xelplus - Leila Gharani.

]]> How to Sum Cells by Color in Excel https://www.xelplus.com/excel-sum-cells-by-color-vba/ Thu, 18 Jul 2019 09:00:00 +0000 https://www.xelplus.com/?p=12283 Use this Excel formula to sum cell values based on cell color. The formula is an Excel VBA function. Copy and paste the code in your files so you can sum values based on background cell color.

The post How to Sum Cells by Color in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA https://www.xelplus.com/list-box-to-print-multiple-sheets-excel-vba/ Sun, 05 May 2019 10:48:00 +0000 https://www.xelplus.com/?p=12473 In this Excel VBA & macros tutorial, you will learn how to create a ListBox that contains the names of the worksheets. You can select multiple names and then print the sheets as one print job instead of separate ones.

The post Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA appeared first on Xelplus - Leila Gharani.

]]> 3 Methods to Unhide All Sheets in Excel (& how to hide) https://www.xelplus.com/3-methods-to-unhide-all-sheets-in-excel/ Thu, 07 Mar 2019 12:17:00 +0000 https://www.xelplus.com/?p=12816 Learn how to quickly hide and unhide all worksheets in at once. Hiding sheets in Excel is easy, but unhiding all sheets is not as simple. I show you 3 methods to unhide Excel tabs. Pick the one you like most.

The post 3 Methods to Unhide All Sheets in Excel (& how to hide) appeared first on Xelplus - Leila Gharani.

]]>