VLOOKUP In VBA – With Examples

In my earlier post, I had written about VLOOKUP in Excel. It was a massive post of around 2500 words, it explains most of the things about the vertical lookup function in excel. Today’s post is an extension to that post and here we will understand how to apply a VLOOKUP in VBA.If you haven’t read that post then I would strongly recommend you … [Read more...]

VBA MsgBox – How to use

In VBA, the MsgBox function is used for displaying a dialog box with a predefined message. It returns an integer value based on the button clicked by the user, this helps to keep a track of the option selected by the user.VBA Msgbox can be mainly used for the below three reasons: For displaying a message to the end-user. For graceful … [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 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 that match … [Read more...]

VBA Split Function – How to Use

VBA, just like any other language gives you a set of functions to perform various operations on strings. And VBA Split is one of those string functions. Microsoft introduced the Split function with VBA Version 6 (in Office 2000).As the name suggests, the job of a Split statement is to break, split, or divide a string based on a particular … [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 Replace Function – How to Use in Excel

VBA Replace is a quite useful string function in Excel VBA. Functions like replace ease your tasks while dealing with strings.As the name suggests the job of the Replace function is to substitute a set of characters in a string with a new set of characters.In Excel VBA there are two functions that can be used for performing string replace … [Read more...]

Adding Current Date and Time Stamp in Excel

Sometimes it happens that you might want to enter the current date and time stamp in your excel spreadsheets automatically. This need usually arrives because of various reasons, in my case I was urged to find a solution to it as I need to do some team management wherein I required the time my associates are spending on work daily. So, in this case … [Read more...]

NETWORKDAYS Function In Excel

The best thing about Excel is that it gives us a wide variety of options to choose from its functions based on our needs. And today, we are going to have a look at a similar function, i.e. NETWORKDAYS. Using this function in excel you can easily calculate the number of weekdays between two dates.As the name suggests, NETWORKDAYS Function in … [Read more...]