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...
Function: LAMBDA

Function: LAMBDA

LAMBDA is a special function that can create custom functions in the scope of a named range. You can essentially create a user defined function without any VBA, macro, or JavaScript knowledge. In this guide, we’re going to show you how to use the LAMBDA function and...
How to calculate the volume of a sphere in Excel

How to calculate the volume of a sphere in Excel

In this guide, we're going to show you how to calculate the volume of a sphere in Excel. Download Workbook The formula for finding the volume of a sphere is the following: The number π is a mathematical constant defined as the ratio of a circle's circumference to its...
How to do an image lookup in Excel

How to do an image lookup in Excel

Excel’s lookup functions recently welcomed the addition of XLOOKUP and XMATCH. However, neither these new functions or the existing ones don’t support image lookup. In this guide, we’re going to show you how to make image lookup in Excel. Download Workbook...
How to change case in Excel

How to change case in Excel

In this article, we are going to show you how to change case in Excel using different methods. Download Workbook Unlike in Word, Excel doesn’t have any built-in features that can help modify the text case. However, some of the methods we will be looking at in...