Latest Blog Posts - Page 66 of 584

Excel VBA Call Sub from Another Module

Jun 17, 2024

Method 1 - Using Call Function Using the Call Function we can call a sub and execute the task inside the sub directly. There are ...

VBA Instr Case Insensitive (2 Suitable Examples)

Nov 11, 2025

In this article, I am going to show you how to make the VBA Instr function case insensitive in Excel. First, we will look at the syntax and ...

VBA Instr Case Insensitive (2 Suitable Examples)

How to Use VBA to Create Pivot Table from Named Range in Excel

Nov 11, 2025

In this article, we will explore the step-by-step process of using VBA to create a Pivot Table from named range using Excel VBA. Excel Pivot Tables ...

How to Use VBA to Create Pivot Table from Named Range in Excel

How to Use Excel VBA to Create a Pivot Table (3 Examples)

May 26, 2024

Method 1 - Inserting a Pivot Table with CreatePivotTable Command Steps: Create a dataset to insert the pivot table. Check out our ...

How to Use Excel VBA to Create a Pivot Table (3 Examples)

How to Run a Private Sub in VBA (3 Methods)

Aug 6, 2024

Here's an overview of a private sub in VBA. What Does Private Sub Mean in Visual Basic? A private sub refers to a subroutine or method ...

How to Run a Private Sub in VBA (3 Methods)

How to Do Excel Data Analysis Correlation (4 Easy Ways)

Jun 13, 2024

Here's a sample example of using the correlation coefficient to analyze data. Download the Practice Workbook Download this practice ...

How to Do Excel Data Analysis Correlation (4 Easy Ways)

Use Excel VBA to Create Chart from Pivot Table

Jul 10, 2024

Here's an overview of using VBA to create a chart from a pivot table. Use Excel VBA to Create Chart from Pivot Table: 3 Methods We have ...

Excel Slicer Multiple Columns: 3 Examples

May 24, 2024

Method 1 - Excel Slicer with Multiple Columns Find all the columns in the Excel slicer in a single column. You can see the below image. ...

Excel Slicer Multiple Columns: 3 Examples

How to Use Excel VBA Sub to Return Value

Nov 11, 2025

In this article, we will learn how to execute Excel VBA sub to return value using the ByRef keyword in different ways. VBA is a programming language ...

How to Use Excel VBA Sub to Return Value

Excel VBA to Call Sub with Parameters (3 Suitable Examples)

Jul 7, 2024

If you want to learn Visual Basic for Applications (Excel VBA), one of the most important concepts to know is Subroutines with parameters and how to ...

Excel VBA to Call Sub with Parameters (3 Suitable Examples)

Using the Excel VBA Function to Return Multiple Values – 6 Methods

Aug 10, 2024

The image below showcases how three results can be obtained, using the ByRef argument in the Excel VBA function. Method 1 - Returning ...

Using the Excel VBA Function to Return Multiple Values – 6 Methods

Excel VBA to Call Private Sub from Another Module

Nov 11, 2025

In this article, we will discuss VBA codes to call Private Sub from another module. A Private Sub is a subroutine that can be accessible from the ...

Excel VBA to Call Private Sub from Another Module

How to Define a Global Array in Excel VBA – 2 Methods

Aug 11, 2024

This is an overview. What Is a Global Array in Excel? In VBA (Visual Basic for Applications), a global array is an array that is declared ...

How to Define a Global Array in Excel VBA – 2 Methods

Excel VBA Private Sub vs Sub (Comparison & Differences)

Nov 11, 2025

The blog post compares Private Sub and Sub in VBA (Visual Basic for Applications) programming and explains their differences. The blog post will ...

Excel VBA Private Sub vs Sub (Comparison & Differences)

How to Call Private Sub in Excel VBA (4 Simple Ways)

Nov 11, 2025

Visual Basic for Applications (VBA) is a programming language commonly used in Microsoft Excel, Word, and other Office applications. Calling a Sub or ...