VBA and Macro

Today we will learn about arrays in VBA. We will learn about how to declare and initialize arrays of different data types to store values.… Read Article

Today we will learn about an important type of loop which is For Each loop in VBA Excel. Loops are a special type of control… Read Article

In this article, we will learn how to clear a cell’s contents, the range of cells or, the named range. We would also learn to… Read Article

Today we would learn about how to check if a cell is empty using VBA in Excel. We would also learn to count the total… Read Article

In this tutorial, we would learn about different ways to merge cells using VBA. We would also write a Sub Procedure that merges the cells… Read Article

In one of our previous articles, we learned about Collections. Today we will learn about one of the most used and important collections that is… Read Article

You must know about an Active Workbook in Excel. In this blog, we will learn about some properties and methods for ThisWorkbook in VBA and… Read Article

We can sort a range of cells in excel using simple ways like the Sort option or SORT Function. VBA is required to sort a… Read Article

Worksheet Events are important to learn. There are times when we want to run a macro/sub procedure when a cell changes its value when the… Read Article

In this blog, we will learn about getting data from our worksheet, writing data into a worksheet with the help of Cell Value. So let… Read Article

In the previous article, we learned about the MsgBox Function. MsgBox Function is helpful for output while the InputBox function in VBA is useful for… Read Article

In this tutorial, we would learn about a very important functionality provided by VBA. We will learn about Message Box and its Syntax along with… Read Article