Macros & Excel VBA Archives - Page 48 of 70

Excel VBA: Getting the Cell Value from Another Workbook without Opening it – 2 Examples

Aug 3, 2024

How to Launch the VBA Editor in Excel Go to the Developer tab. Select Visual Basic. A new window will open. Select Insert, ...

Excel VBA: Getting the Cell Value from Another Workbook without Opening it – 2 Examples

Excel VBA Codes to Bold Text in a String (5 Examples)

Jun 18, 2024

In this tutorial, you will learn how to make a text bold in a string using Excel VBA, along with other related tasks. Example 1 - Bold the ...

Excel VBA Codes to Bold Text in a String (5 Examples)

Text Alignment with VBA Command Button in Excel (5 Methods)

Nov 11, 2025

In this article, we will learn text alignment with the command button in Excel using VBA. Text alignment is a necessary thing to represent a clean ...

Text Alignment with VBA Command Button in Excel (5 Methods)

How to Delete Columns Based on the Header Using VBA in Excel – 6 Methods

Aug 12, 2024

The sample dataset showcases sold Products, Order Date, City, Category, Quantity, and Unit Price. To delete columns: Opening ...

How to Delete Columns Based on the Header Using VBA in Excel – 6 Methods

How to Copy Data from Another Workbook without Opening with Excel VBA: 3 Different Ways

May 28, 2024

We will use a sample Workbook named Product_Details and copy the data range (B4:E10) to another Workbook. Method 1 - Copy a Sheet Data ...

How to Copy Data from Another Workbook without Opening with Excel VBA: 3 Different Ways

How to Copy Values and Formats with Paste Special in Excel VBA

Jun 18, 2024

Method 1 – Applying an InputBox in VBA Paste Special Steps: Go to the Developer tab. Click on Record Macro. Set Excel_Paste_Special_1 ...

How to Copy Values and Formats with Paste Special in Excel VBA

Using VBA to Count Duplicates in a Range in Excel – 4 Methods

Aug 11, 2024

Method 1 - Embed VBA to Count Duplicate Values in a Range in Excel In the following dataset, Column B contains random numbers. D5 displays 2473. ...

Using VBA to Count Duplicates in a Range in Excel – 4 Methods

Using VBA to Copy a Formula from the Cell Above in Excel – 10 Methods

Aug 3, 2024

This is an overview. The dataset shows mathematical results in column B. The formula behind the results for each cell is shown in Column D. If ...

Using VBA to Copy a Formula from the Cell Above in Excel – 10 Methods

How to Apply VBA PasteSpecial and Keep Source Formatting in Excel: 4 Easy Examples

Jul 5, 2024

Method 1 - Add Input Box by Using VBA PasteSpecial and Keep Source Formatting in Excel Press Alt + F11 to start a Macro. Click on the ...

How to Apply VBA PasteSpecial and Keep Source Formatting in Excel: 4 Easy Examples

AutoFill Formula to Last Row with Excel VBA (5 Examples)

Jun 13, 2024

What Is AutoFill in Excel? Autofill is a built-in feature of Microsoft Excel that allows users to automatically fill the rest of the rows or ...

AutoFill Formula to Last Row with Excel VBA (5 Examples)

Copy and Paste Values to Next Empty Row with Excel VBA (3 Examples)

Jun 15, 2024

Method 1 - Copy a Range of Cells and Paste Values from the Next Empty Row in Excel Using VBA Code In this particular example, we will copy row 11 ...

Copy and Paste Values to Next Empty Row with Excel VBA (3 Examples)

How to Delete Hidden Rows in Excel VBA (Step-by-Step Analysis)

Nov 11, 2025

In this article, I’ll show you how you can delete hidden rows from a worksheet with VBA in Excel. You’ll learn to delete hidden rows from both a ...

How to Delete Hidden Rows in Excel VBA (Step-by-Step Analysis)

Excel VBA: Delete Sheet If It Exists (4 Methods)

Nov 11, 2025

In this article, we’ll illustrate how to delete a sheet if it exists from a workbook using VBA in Excel with 4 examples. As deleting worksheets is a ...

Excel VBA: Delete Sheet If It Exists (4 Methods)

How to Delete a Row Using Macro If a Cell Contains 0 in Excel (4 Methods)

Jul 6, 2024

The dataset below shows the Number of Visits, the Names of the Sites, and the Dates. Some sites have a cell value (Number of Visits) of 0. In such a ...

How to Delete a Row Using Macro If a Cell Contains 0 in Excel (4 Methods)

How to Count Filled Cells in Excel Using VBA: 7 Methods

Jun 4, 2024

Method 1 - Use VBA Macro to Count Filled Cells from a Range Step 1: Open Microsoft Visual Basic, insert a Module using the instruction section. ...