Latest Blog Posts - Page 81 of 584

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

Jul 4, 2024

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 ...

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

[Fixed!!] VBA Sort Not Working in Excel

Nov 11, 2025

In VBA, sorting data is a common task, but it can be frustrating when the sort function doesn't work as expected. This article will discuss the ...

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

Jul 10, 2024

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 ...

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

Excel VBA Select Case True

Nov 11, 2025

VBA Select Case True is a very useful statement while working with multiple conditions. This statement is more concise and presents the ...

How to Use UBound on Multidimensional Array with VBA in Excel

Nov 11, 2025

Today, we are going to discuss how to use the UBound function on a multidimensional array with VBA. This function is a very commonly used Array ...

How to Use UBound on Multidimensional Array with VBA in Excel

Excel VBA Sort Array Alphabetically

Nov 11, 2025

Sorting is an essential operation that involves arranging a set of data in ascending or descending order based on their numeric values or leading ...

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

May 22, 2024

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 ...

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

Excel VBA Array of Arrays (3 Examples)

Nov 11, 2025

The array of arrays, also known as a Jagged Array, is a two-dimensional array where each element of the first dimension is an array. You can access ...

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

Aug 1, 2024

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

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

Excel Formula to Calculate Number of Days Between Two Dates

Jul 6, 2024

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

Excel Formula to Calculate Number of Days Between Two Dates

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

Jul 2, 2024

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 Select Row Based on Cell Value (3 Ways)

Excel VBA to Declare Multidimensional Array of Unknown Size

Nov 11, 2025

In Excel VBA, multidimensional arrays are a powerful tool for handling complex data structures. They allow you to store and manipulate data in a way ...