How to run macro at a specified time in Excel

How to run macro at a specified time in Excel

With Application.OnTime method, you can set Excel to run some VBA at a specific time, or repeatedly at set intervals. In this guide, we're going to show you how to run macro at a specified time in Excel. Download Workbook Application.OnTime VBA’s Application.OnTime...
How to count cells by font color in Excel

How to count cells by font color in Excel

Although Excel doesn’t have a built-in feature for counting cells based on their font colors, filtering results by their font color is possible. In this guide, we’re going to show you how to count cells by font color in Excel. Download Workbook Steps Right-click...
How to count colored cells in Excel

How to count colored cells in Excel

Although Excel doesn’t have a built-in feature to count cells by their colors, filtering cells by their color is possible. In this guide, we’re going to show you how to count colored cells in Excel. Download Workbook Steps Right-click on a colored cell in the...
How to refer a range or a cell in Excel VBA

How to refer a range or a cell in Excel VBA

In this guide, we’re going to show you how to refer a range or a cell in Excel VBA. VBA Basics Before diving into the code, let’s start with a cell or a range means in VBA. First, VBA is an object-based programming language, which means that the language refers...
How to format numbers as file sizes in Excel

How to format numbers as file sizes in Excel

Excel’s number formatting doesn’t support file sizes by default. However, it allows you to program your own formatting style. In this guide, we’re going to show you how to format numbers as file sizes in Excel. Download Workbook The number formatting is one the...