Loop Archives - Xelplus - Leila Gharani

How to Use Office Scripts with Power Automate

Leila Gharani — Thu, 12 Aug 2021 08:00:00 +0000

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.

How to Send an Email from Excel with Attachments

Leila Gharani — Thu, 29 Apr 2021 08:00:00 +0000

Guess what? You can send bulk personalized emails directly from Excel with attachments. You don't need any VBA or external add-ins. It's really easy to set this up.

The post How to Send an Email from Excel with Attachments appeared first on Xelplus - Leila Gharani.

How to Create a Custom Progress Bar in Excel with VBA

Leila Gharani — Wed, 15 Apr 2020 09:00:00 +0000

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 Sum Cells by Color in Excel

Leila Gharani — Thu, 18 Jul 2019 09:00:00 +0000

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 VBA: Loop Through Cells Inside the Used Range (For Each Collection Loop)

Leila Gharani — Sat, 05 Jan 2019 16:54:00 +0000

Learn how to use the FOR EACH Collection Loop in Excel VBA. This way you can quickly loop inside a specific range, manipute the data or check for a condition. In this example we count the number of cells that contain formulas in the UsedRange.

The post Excel VBA: Loop Through Cells Inside the Used Range (For Each Collection Loop) appeared first on Xelplus - Leila Gharani.

Excel VBA IF THEN Statement (and a useful tip)

Leila Gharani — Thu, 23 Aug 2018 16:15:00 +0000

Learn one of the most useful statements in VBA (or any programming language, really): If Then. Once you master If, Then, Else, Elseif and And, you will be able to write Excel macros that are dependent on multiple conditions.

The post Excel VBA IF THEN Statement (and a useful tip) appeared first on Xelplus - Leila Gharani.