Macros & Excel VBA

How to Hide Formula in Excel Using VBA (4 Methods)

Sometimes we want to hide formulas for certain results to make any large worksheet less crowded. Implementing VBA is the most effective, quickest, ...

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

When we have a large amount of data then sometimes it is hard to extract any specific data from the dataset. Together with Excel’s INDEX and MATCH ...

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

We’re going to show you 2 methods of Excel VBA to insert picture from URL. To demonstrate our methods, we’ve picked a dataset with 3 columns: #, ...

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

In this article, I’ll show you how you can insert an image into a cell with Excel VBA. Insert an Image into a Cell with Excel VBA (Quick View) ...

VBA to Select Value from Drop Down List in Excel (2 Methods)

Dropdown lists are a very useful feature to perform various Excel related tasks. Implementing VBA is the most effective, quickest, and safest method ...

Excel VBA: Insert Picture from Folder (3 Methods)

This article illustrates how to insert a picture in Excel from the storage folder using VBA code with 2 different methods. We’ll be able to insert ...

Excel VBA: UserForm Image from Worksheet (3 Cases)

While creating or modifying a UserForm, you may need to add or create images from the worksheet. In this instructive session, I’ll demonstrate 3 ...

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

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. ...

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

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 ...

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

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 ...

Unique Values in a Drop Down List with VBA in Excel (A Complete Guide)

In this article, I’ll show you how you can remove the duplicate values from a drop down list of a worksheet in Excel with the help of VBA and keep ...

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

This article illustrates how to define a dynamic range in Excel based on a cell value using VBA code. We’re going to explain 3 different examples to ...

How to Count Rows in Selection Using VBA in Excel

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 ...

Excel VBA: Count Columns with Data (2 Examples)

When you have a small data table with a few columns, you can easily count them all. But for a large data table, it’s quite difficult to count all the ...

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

In this article, we will learn to find and replace multiple values in excel with VBA. VBA stands for Visual Basic for Applications. It is a ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo