FileSystemObject in VBA – Explained

FileSystemObject also called as FSO, provides an easy object based model to access computer’s file system. You simply have to create an instance of FileSystemObject in VBA and then you can generate files, read files, delete files, iterate though folders and do many other operations on your computer’s file system.The FileSystemObject is present … [Read more...]

VBA DIR Function – How to Use in Excel

DIR is a very special function in VBA, its job is to return a string representing the name of a file, directory, or an archive that matches a specified pattern. DIR function only returns the first file name or folder name from a location that matches the specified attributes.To fetch other file names or folder names from that location which … [Read more...]

VBA Loops – For, For Each, Do While and Do Until Loops

Loops are used in VBA for repeating a set of statements multiple times. Loops form a very important part of any programming language and VBA is no exception. There are different types of loops that can be used in VBA. These are as follows: 1. VBA For Loop2. VBA For Each Loop3. VBA Do While Loop4. VBA Do Until Loop In this … [Read more...]

Excel VLOOKUP – Massive Guide with 8 Examples

VLOOKUP is one of the most useful and important functions in Microsoft Excel. It is generally used to look up a particular value in huge data sheets where manual intervention can be cumbersome. The alphabet ‘V’ in VLOOKUP stands for “Vertical” so this function is sometimes also called vertical lookup.The term “Vertical” signifies that it can be … [Read more...]

VBA Wait and Sleep Functions – Explained

Wait and Sleep functionality in programs is required to hold or pause the program execution for a specified time. These methods suspend all the activities of Microsoft Excel and sometimes may also prevent you from performing other operations on it until the pause is in effect.However your computer can simultaneously process other background … [Read more...]

How to Alphabetize in Excel – The Complete Guide

Most people know how to alphabetize a list in excel, but few of them actually know the best and fastest ways to do it. In this tutorial I am going to highlight some of the best methods to alphabetize in Excel.What does alphabetizing a column means and what are its uses:Alphabetizing a column or list means sorting a list alphabetically in excel. … [Read more...]

VBA InputBox – How to Use

In earlier post we have talked about MsgBox which is exactly opposite to VBA InputBox. The job of InputBox function in VBA is to get some input from the user. It displays a dialog to the user that gives him a cue of which value should be entered, then it returns this value to the program.Syntax of InputBox in VBA:Its syntax is as … [Read more...]

Hiding Gridlines in Excel

Hiding gridlines in Excel is a common task and most of the Excel users should know about it. It makes your spreadsheet clean and presentable. Although grid lines in excel have their own benefits but in some cases it is better to hide them.What are Gridlines?A spreadsheet contains cells and gridlines or gridbars represent the borders of these … [Read more...]

Privacy Policy | Disclaimer | About