Macros & Excel VBA

Excel VBA to Select Last Row

In Excel, if we need to add a new row after the last row in a large dataset, it can become tedious and time-consuming to go to the last row. Although ...

Activeworkbook Refreshall Not Working [Solved!]

Excel VBA Refresh All Open Workbooks The ActiveWorkbook.RefreshAll method is used to refresh all the existing data connections and pivot tables in a ...

How to Use the Excel VBA INDEX MATCH Function in Another Worksheet – 3 Methods

This is an overview: The sample dataset showcases Names. Date and Quantity sold. The dataset is in sheet1 and the result sheets are sheet2 ...

How to Use Excel VBA Text to Columns Date Format (2 Examples)

The article demonstrates how to create a VBA macro that automates the Text to Columns process and converts text dates into Excel date format. ...

Using Excel VBA to Format a Number with a Leading Zero – 4 Methods

How to Launch the VBA Editor in Excel Enable the Developer tab on your ribbon. Go to the Developer tab. Select Visual Basic. Select ...

Loop Through Excel Files in Folder with VBA: 5 Suitable Examples

Method 1 - Loop Through Excel Files in Folder by Dir Function The Dir function in VBA retrieves the name of a file or folder that matches a ...

Different Cases That Will Teach You to Work with a Variable in Excel VBA MsgBox: 5 Methods

Method 1 - MsgBox with Improper Variable Type Declaration While working in Excel VBA, we encounter various errors. Run-time error ‘13’ occurs ...

How to Filter ComboBox Data in Excel VBA

A ComboBox allows users to select from a list of predefined items. However if the list is too big, It may become difficult to find a required item. ...

How to Use Target Address in Excel VBA (3 Examples)

  The sample dataset contains the production and selling prices of different mobile phones. We are going to use Target.Address to change cell ...

Excel VBA: InputBox with Default Value

Looking for ways to create Inputbox with default value in Excel VBA? Then, this is the right place for you. Default value is an important feature ...

How to Create Yes No InputBox with Excel VBA

Looking for ways to create Yes No InputBox with Excel VBA? Then, this is the right place for you. Excel has InputBox and MsgBox for inserting ...

Excel VBA: Running a Backwards For Loop

In this article, we will discuss how to use the For Loop statement in Excel VBA to loop through a range of cells backwards. We will explain the ...

VBA Delete Rows

In this article, we will talk about and show how to use VBA to delete a row or rows in Excel. We will go through some easy techniques to do the task ...

How to Use the VBA Input Box with Buttons in Excel – 2 Examples

The Input Box in Excel The Input Box is a dialog box that takes input from the users. It has two buttons: OK and Cancel. Syntax of the ...

Run Time Error 1004: Select Method of Range Class Failed – Reason and Solutions

How to Launch the VBA Macro Editor in Excel Go to Developer Tab >> Visual Basic. The Visual Basic window is displayed. Select ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo