Latest Blog Posts

How to Use the Intersection Operator in Excel – 5 Examples

Example 1 - Use the Intersection Command and a Function Button in Excel Steps: Press F9. Enter the first level of rows, here C5:E7. Enter ...

How to Use Excel VBA to Lookup Value in Range (5 Examples)

Here is a sample video of our work on VBA LOOKUP values in a range in Excel. How to Open VBA Macro Editor in Excel VBA is a programming ...

How to Concatenate Different Fonts in Excel – 2 Methods

Method 1 - Use the Cells.Value Property in VBA to Join Different Fonts Go to the Developer tab >> select Visual Basic. You can also ...

Excel VBA Select Case Like: 7 Examples

Syntax of the Select Case Statement The basic syntax for the Select Case statement in VBA is as follows: Select Case expression Case value1 ...

Excel VBA to Find Cell Address Based on Value (3 Examples)

The sample dataset contains the sales data of a certain showroom. Example 1 - Finding Only First Cell Address Based on Value By default, ...

Using the Excel VBA ActiveCell Offset Property – 13 Examples

How to Launch the VBA Editor in Excel The Developer tab contains the VBA applications. Enable the Developer tab. Note: By default, the Developer ...

Excel VBA 2 Dimensional Array Initialization

Overview of a 2-Dimensional Array (2D Array) Definition A 2-dimensional array, also known as a 2D array, is an array that has data spread out ...

Export Folder and Subfolder List to Excel (with Quick Steps)

The Power Query tool can be used to export .xlsx and .txt file inside a folder and subfolder list to Excel. Step 1 - Choose a Folder from ...

How to Use an Array of Strings in VBA (4 Examples)

Introduction to VBA Array Arrays are powerful tools for managing data, and they allow you to group related values under a single variable name. Here ...

Create InputBox with Multiple Inputs With VBA UserForm in Excel: 8 Step-by-Step Methods

Method 1 - Insert User Form to Create InputBox with Multiple Inputs in Excel The Visual Basic window will open. We’ll insert an UserForm from the ...

How to Redim 2D Array with VBA in Excel (3 Examples)

Here's the overview of performing ReDim 2D array in Excel VBA. Here, we decrease the array size.   How to Open the VBA Macro ...

Excel Formula to Calculate Number of Days Between Two Dates

In this article we will demonstrate several methods to calculate the number of days between two dates using a simple formula. Download ...

Excel VBA Select Row Based on Cell Value (3 Ways)

In this article, we'll discuss various methods to select rows based on cell value using VBA, along with recommended practices and potential problems. ...

Excel VBA Multidimensional Array for Assigning Values (6 Ways)

How to Launch the VBA Editor in Excel Go to the Developer tab and select Visual Basic under Code. Alternative command: Pressing Alt + F11 ...

Using Excel VBA to Sort in Descending Order – 6 Examples

How to Launch the VBA Editor in Excel Utilizing the Module Tool: Open your workbook and select Visual Basic in the Developer tab. ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo