Skip to content

Tag Archives: Excel-VBA

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: For… Read More

Start Your Coding Journey Now!