Step #1: Identify the Excel Range First off, open your Microsoft Excel spreadsheet and identify the cell range in which…
How to save Excel file with specific name and current date with VBA?
In this short tutorial we will learn how you can use Visual Basic for Applications (VBA) to automate the saving…
In this tutorial we’ll learn how to use Visual Basic for Applications (VBA) to modify text size and style in…
How to check if a file or folder exists in your computer with Excel VBA?
Today’s Office automation tutorial is focused on learning how to verify that a file exists in one of your computer…
How to check if a cell or a range of multiple cells is empty with Excel VBA?
Today we’ll learn about how to easily check whether one or multiple cells are empty using Visual Basic for Applications….
How to set an Excel cell color according to a condition with VBA?
Applies to: Microsoft Excel 365, 2021, 2019, 2016. In today’s VBA for Excel Automation tutorial we’ll learn about how we…
Updated: August 2021; Works on Excel 365, 2019, 2016. In today’s Excel automation tutorial we will learn how to quickly…
Here’s a question from Danny: I have recently started using Microsoft Visio to make use of diagrams, layouts, and charts….
Going through the comments, i have seen a couple of reader questions on how to work with Visual Basic Input…
When trying to make sense of a large DataFrame in Pandas, you might need to subset it by columns and…
Couple days ago, i wanted to automate the rather mundane task of creating some PowerPoint slides. When automating PowerPoint you…
How to create and add slides to PowerPoint presentations with VBA?
A couple days ago, a reader asked about there is a way to automate creation of PowerPoint presentations from scratch…
How to display the developer tab in Excel, Outlook and Word 2019 / 365?
Here’s a question we got from a reader: I am trying to figure out macro development from going through code…
How to copy add slides into your PowerPoint presentation with VBA Macros?
Last updated: June 2020 Applicable to: Office 2019 and older. Windows only. Here’s a question from a reader: As part…