Macros & Excel VBA Archives - Page 37 of 70

Excel VBA: Split String into Cells (4 Useful Applications)

Nov 11, 2025

The article will provide you with some useful applications to split string(s) into cells by Excel VBA. We do this often to see necessary data ...

Excel VBA: Split String into Cells (4 Useful Applications)

How to Filter a Table based on Cell Values with Excel VBA (6 Methods)

Jul 27, 2024

Dataset Overview We've included a sample dataset in the figure below, from which we'll sift through values according to specific cell criteria. ...

How to Filter a Table based on Cell Values with Excel VBA (6 Methods)

How to Remove Filter in Excel VBA (5 Simple Methods)

Apr 29, 2024

To remove filters from data, we are going to use the following dataset. It contains some product IDs in column B, product names in column C, and the ...

How to Remove Filter in Excel VBA (5 Simple Methods)

Excel VBA: Split String by Number of Characters (2 Easy Methods)

Nov 11, 2025

In this article, I’ll show you how you split a string by any given number of characters using VBA in Excel. Split String by Number of ...

Excel VBA: Split String by Number of Characters (2 Easy Methods)

Subtracting One Range from Another in Excel VBA – 3 Examples

Aug 14, 2024

The following dataset contains sales records of different products in different regions. Example 1 - Getting a Range Address ...

Subtracting One Range from Another in Excel VBA – 3 Examples

Excel VBA: Split String into Rows (6 Ideal Examples)

Nov 11, 2025

In this method, we’re going to show you 6 ways for Excel VBA split string(s) into rows. To demonstrate our methods, we’ve chosen a dataset with 2 ...

Excel VBA: Split String into Rows (6 Ideal Examples)

How to Hide Blank Rows in Excel VBA (4 Examples)

Jul 5, 2024

Below is a dataset of the sale details for different products. It contains a couple of blank rows that we will hide using simple VBA code. The ...

How to Hide Blank Rows in Excel VBA (4 Examples)

Excel VBA: Unhide All Rows in Excel (5 Practical Examples)

Nov 11, 2025

The article will provide you with some basic concepts on how to unhide all rows by using Excel VBA. Suppose, you had a large dataset and you didn’t ...

Excel VBA: Unhide All Rows in Excel (5 Practical Examples)

Using a VBA IF Statement with Multiple Conditions in Excel – 8 Methods

Aug 9, 2024

Method 1 - Using a VBA IF Statement with Multiple Conditions: IF with OR Consider the following macro. Sub IfWithOr() If 5 < 10 Or 10 < 5 ...

Using a VBA IF Statement with Multiple Conditions in Excel – 8 Methods

Split a Workbook to Separate Excel Files with VBA Code: 3 Ways

Jul 7, 2024

Method 1 - Split a Worksheet of a Workbook Based on a Column to Separate Excel Files Step-01: ➤ Go to the Developer Tab >> Visual Basic ...

Split a Workbook to Separate Excel Files with VBA Code: 3 Ways

Excel VBA: Get Row and Column Number from Cell Address (4 Methods)

Jul 9, 2024

How to Write Code in the Visual Basic Editor To get row and column numbers from cell addresses, we need to open and write VBA code in the Visual ...

Excel VBA: Get Row and Column Number from Cell Address (4 Methods)

Excel VBA: Create New Line in MsgBox (6 Examples)

Jul 5, 2024

Example 1 - Use vbNewLine to Add New Line in MsgBox Using Excel VBA We will show “Hello!” in the first line and “Welcome to ExcelDemy” in the second ...