Recent Posts

Understanding Objects in VBA

An object in VBA is an Excel component such as a workbook, worksheet, or range, that you can interact with and manipulate. These are...

Power Query

How to Refresh Power Query using VBA

Avoid manually running your query by hand every time and automate it using a few easy macros. Contents: 1. Macros 1.1. Refresh a Specific...

Tutorial

How to Sum Cells By Color in Excel

While not a built-in Excel feature, we can create our own function to easily sum cells by color. Contents: 1. How to Use VBA User Defined...

Tutorial

How to Enable the Developer Tab in Excel

The Developer tab in Excel is hidden by default, but offers some very important functions and built in features that every Excel Expert...

Tutorial

How to Count Colored Cells in Excel

While not a built-in Excel feature, we can create our own function to easily count colored cells. Contents: 1. How to Use VBA User...

Project

Creating Fully Playable Yahtzee in Excel

Contents: 1. Download 2. How to Play 3. How Does it Work? 3.1 Dice Display 3.2 Rolling & Freezing Dice 3.3 Score Keeping & Entry 3.4 Turn...

VBA & Macros

Understanding Dynamic Arrays - VBA Tutorial

A dynamic array is an array that can change size on the fly, unlike a static array that has a fixed number of elements. Contents: 1. What...

VBA & Macros

What are Macros? Are They Hard to Learn? Should You? - VBA Tutorial

Macros are used inside an Excel workbook that automate repetitive and complex tasks, allowing you to streamline your workflow and save...

VBA & Macros

How to Create a Macro in Excel - VBA Tutorial

Knowing how to create macros will let you automate repetitive tasks and create your own customized features and functions in Excel. There...

VBA & Macros

What are Arrays and How to Use Them - VBA Tutorial

An array is a set of values that are stored in a structured, linear way, allowing you to store and manipulate a large number of values in...

VBA & Macros

What are With Statements and How to Use Them - VBA Tutorial

In VBA, a with statement is used to reference an object multiple times within a specific block of code. Reducing typing and creating more...

VBA & Macros

What are Do While Loops and How to Use Them - VBA Tutorial

In VBA, a Do While loop is a type of loop that will continue to repeat a set of instructions until a specific condition is met. Contents:...

VBA & Macros

VBA Naming Conventions & How to Write Good Variable Names - VBA Tutorial

Naming your variables properly is an important, but often overlooking, building block that, once learned, will improve your codes...

VBA & Macros

How to Declare Variables and Data Types - VBA Tutorial

Declaring variables is an essential part of programming in VBA. Declaring properly will help you avoid errors and improve the overall...

VBA & Macros

How to Structure VBA Code and Macros in Excel - VBA Tutorial

When creating macros and writing VBA, it is important to logically structure your code to maximize readability and ensure your code is as...

VBA & Macros

How to Write Presentable VBA Code and Macros - VBA Tutorial

Good code presentation is an important part of writing VBA (or any other programming language for that matter), and will make your code...

VBA & Macros

What are For Loops and How to Use Them - VBA Tutorial

For loops are an essential programming method used across many different languages, and allow for more precise, readable, and flexible...

Tutorial

How to Update Pivot Table Data Sources on New & Copied Workbooks with VBA

When copying workbooks, sometimes Pivot Tables/Caches Won't update and link properly, here's a work around.