Skip to content

Tag Archives: Excel-VBA

We use UBound and LBound functions to get the length of an Array in Excel VBA. In this article, we will discuss them in detail.… Read More
We can use Select case instead of using multiple if then statements in Excel VBA. In the below example user will enter the student mark… Read More
We use  Range.SpecialCells() method in the below VBA Code to find and return details of last used row, column, and cell in a worksheet. Sample… Read More
Excel VBA code to remove duplicates from a given range of cells. In the below data set we have given a list of 15 numbers… Read More
There might arise a situation while working on Excel where you want the users to type in 10-digits(say)  numbers only in a cell. In these… Read More
VBA Program to read a Text file line by line (Sales Data) and places on a worksheet.  Sales Data in Text File: 5 Fields [… Read More
This VBA Program reads an Excel Range (Sales Data) and write to a Text file (Sales.txt) Excel VBA code to read data from an Excel… Read More
In Excel, managing space is a very important point to consider. Now, let’s suppose you are in a situation where you want to compare multiple… Read More
Logical operators are used for performing logical and asthmatic operations on a set of values or variables. The table depicts all the different types of… Read More
If you are familiar with the programming you must have an idea of what a loop is, In computer programming, a loop is a sequence… Read More
Microsoft Excel’s Wrap text allows the content of the cell to appear on multiple lines within a cell; rather than a long line. This feature… Read More
A Do…While loop is used when we want to repeat certain set of statements as long as the condition is true. The condition may be… Read More
A For Each loop is used to execute a statement or a set of statements for each element in an array or collection. Syntax:Attention reader!… Read More

Start Your Coding Journey Now!