Macros & Excel VBA Archives - Page 44 of 70

How to Hide Formula in Excel Using VBA: 4 Methods

Jun 5, 2024

Method 1 - Embed VBA to Hide the Formula of a Range in Excel Steps to Protect a Sheet: Go to the tab Review. Click Protect Sheet from the ...

How to Hide Formula in Excel Using VBA: 4 Methods

VBA INDEX MATCH Based on Multiple Criteria in Excel (3 Methods)

Jun 20, 2024

This is the sample dataset for illustration. We will extract a certain result residing in one column based on conditions from the other two columns. ...

VBA INDEX MATCH Based on Multiple Criteria in Excel (3 Methods)

How to Insert Picture from URL Using VBA in Excel (2 Methods)

May 23, 2024

We will use the sample dataset below to insert images into the blank column (Image column) from the URLs given in the URL column. Method 1 - ...

How to Insert Picture from URL Using VBA in Excel (2 Methods)

How to Insert an Image into a Cell with Excel VBA (2 Methods)

May 15, 2024

Quick View Sub Insert_Single_Image() Image_Name = "Argentina" Image_Location = "E:\ExcelDemy\National Flags" Image_Format = ".png" ...

How to Insert an Image into a Cell with Excel VBA (2 Methods)

Using VBA to Select a Value from a Drop Down List in Excel – 2 Methods

Aug 3, 2024

Creating a Dropdown List from a Generic List in Excel In the dataset below, there are repeated values (Apple in B7 and B9) . Create a ...

Using VBA to Select a Value from a Drop Down List in Excel – 2 Methods

Excel VBA: Inserting a Picture from the Folder – 3 Methods

Aug 7, 2024

You have pictures in a specific folder and want to insert one of these pictures in your Excel worksheet. Go to the Developer tab. ...

Excel VBA: Inserting a Picture from the Folder – 3 Methods

Excel VBA: Create a UserForm Image from a Worksheet – 3 Examples

Aug 10, 2024

Example 1 - Using the Copy Pasting Tool You have an image in your worksheet. To add this image to the UserForm dialog box: ...

Excel VBA: Create a UserForm Image from a Worksheet – 3 Examples

Find and Replace a Text in a Range with Excel VBA (Macro and UserForm)

Nov 11, 2025

In this article, I’ll show you how you can use Excel VBA to find a specific text and replace it with another text within any range in a worksheet. ...

Find and Replace a Text in a Range with Excel VBA (Macro and UserForm)

Excel VBA: Count Rows in a Sheet (5 Examples)

Nov 11, 2025

Counting the total number of rows in a sheet is quite easy for a smaller size of dataset. However, if the size of the data table becomes large, then ...

Excel VBA: Count Rows in a Sheet (5 Examples)

[Fixed]: Can’t Find Project or Library Error in Excel (3 Solutions)

Nov 11, 2025

While working with a large Microsoft Excel dataset, sometimes we see that our VBA macros show an error named “can’t find project or library”. It ...

[Fixed]: Can’t Find Project or Library Error in Excel (3 Solutions)

How to Keep Unique Values in a Drop Down List with Excel VBA – 3 Methods

Aug 13, 2024

Quick View: Sub Drop_Down_List_Unique_Values_At_Least_Once() List_Location = "B3" Data = Range(List_Location).Validation.Formula1 Data = ...

How to Keep Unique Values in a Drop Down List with Excel VBA – 3 Methods

Excel VBA: Dynamic Range Based on Cell Value (3 Methods)

Jul 23, 2024

How to Write Code in the Visual Basic Editor Go to the Developer tab from the Excel Ribbon. Click the Visual Basic option. In the ...

Excel VBA: Dynamic Range Based on Cell Value (3 Methods)

How to Count Rows in Selection Using VBA in Excel

Nov 11, 2025

In general, a typical Excel workbook contains numerous rows. And these rows may have blank or non-blank entries. Excel VBA count rows in selection is ...

How to Count Rows in Selection Using VBA in Excel

How to Count Columns with Data Using Excel VBA (2 Methods)

Jul 15, 2024

Method 1 - Count All the Columns with Data in a Worksheet Open the VBA editor by pressing ALT + F11. Create a new module from Insert > ...

How to Count Columns with Data Using Excel VBA (2 Methods)

How to Find and Replace Multiple Values in Excel with VBA (3 Examples)

Jun 11, 2024

Below is a dataset that contains information about the departments of employees. We will try to use VBA to find and replace the department's values. ...