Macros & Excel VBA Archives - Page 60 of 70

How to Select Range Based on Cell Value VBA (7 Ways)

Jun 24, 2024

Method 1 - Selecting Range Based On Another Cell Value We will select the cell range in the Region and Sales column based on the string Apple in the ...

How to Select Range Based on Cell Value VBA (7 Ways)

How to Convert Column Number to Letter in Excel (3 Methods)

Jul 12, 2024

Method 1 - Convert Column Number to Letter in Excel Consider the following dataset which we will be using as our example to convert column number to ...

How to Convert Column Number to Letter in Excel (3 Methods)

How to Compare Text and Highlight Differences in Excel (8 Quick Ways)

May 14, 2024

To demonstrate our Methods, we'll use the following dataset containing the names of the best-selling books in an online shop over two consecutive ...

How to Compare Text and Highlight Differences in Excel (8 Quick Ways)

How to Select Columns with VBA (3 Easy Ways)

May 16, 2024

Download the Practice Workbook Selecting Columns with VBA.xlsm 3 Ways to Select Columns with VBA Consider the List of Company ...

How to Select Columns with VBA (3 Easy Ways)

How to Find a Character in Excel String (8 Easy Ways)

Apr 12, 2024

If we want to find specific characters of an Employee’s Name and ID, we have to find characters appearing in the Character Sign column. For a better ...

How to Find a Character in Excel String (8 Easy Ways)

How to Select Cell with VBA in Excel (6 Useful Ways)

Jul 5, 2024

Download the Practice Workbook Select Cell with VBA.xlsm How to Select a Cell with VBA in Excel Method 1 - Select a Cell of the ...

How to Select Cell with VBA in Excel (6 Useful Ways)

VBA Macro to Delete Columns Based on Criteria in Excel: 8 Examples

Jun 27, 2024

Method 1 - VBA Macro to Delete Columns Based on Cell Value in Excel Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> ...

VBA Macro to Delete Columns Based on Criteria in Excel: 8 Examples

How to Use Dynamic Range in Excel VBA (11 Ways)

Jul 6, 2024

We have a dataset of a company to demonstrate the ways of using a dynamic range in VBA. Method 1 - Select Cells Containing Values Through ...

How to Use Dynamic Range in Excel VBA (11 Ways)

VBA to Convert Column Number to Letter in Excel (3 Methods)

Aug 4, 2024

In this article, we will demonstrate how to convert a column number to its corresponding column letter in Excel with VBA code using 3 methods: ...

VBA to Convert Column Number to Letter in Excel (3 Methods)

Macro to Copy Data from One Workbook to Another Based on Criteria

Jun 9, 2024

Suppose we have two workbooks called Workbook1 and Workbook2. In Workbook1 we have the Names, Types, and Prices of some books in a bookshop. ...

Macro to Copy Data from One Workbook to Another Based on Criteria

VBA to Delete Column in Excel (9 Criteria)

Jul 30, 2024

Generic Syntax The generic syntax to delete single or multiple columns in Excel using VBA is: Columns(column number/ column address).Delete ...

VBA to Delete Column in Excel (9 Criteria)

How to Copy Sheet with VBA in Excel: 13 Quick Methods

Jun 12, 2024

Method 1 - Using Excel VBA to Copy a Worksheet in the Same Workbook (Before Any Sheet) Steps: Press ALT + F11 to open the Microsoft Visual ...

How to Copy Sheet with VBA in Excel: 13 Quick Methods

How to Use VBA Range Offset (11 Easy Ways)

Jun 28, 2024

In this article we will demonstrate a variety of ways to use the VBA Range Offset. Here is an overview. 11 Suitable Ways to Use VBA Range ...

How to Use VBA Range Offset (11 Easy Ways)

Split Data into Multiple Worksheets in Excel (with Quick Steps)

May 21, 2024

In this article, we describe how to split data into multiple Excel worksheets using VBA & Macros. In our data set, we have data ...

Split Data into Multiple Worksheets in Excel (with Quick Steps)

How to Loop through a Range for Each Cell Using Excel VBA (8 Examples)

Jun 4, 2024

We will show you step-by-step instructions on applying a loop for each cell in a range using Excel VBA with a simple example. Look at this dataset ...