@TutorialHorizon
Excel-Macro-VBA
This tutorial will teach you how to Open a Excel File using Another Excel File using Browse Option. We will be using Application.GetOpenFile() function to accomplish this. NOTE: You can define any type file...
Say you have many images in a folder and you want to insert all these images in your excel work book, one image in one cell. You can do it manually, insert and resize...
There are two different cases you might deal with, Lock only few specific cells and rest of the cells in the work sheet are not locked(means you can edit them) Lock the Enitre worksheet...
Objective : Suppose you have many worksheets in an excel and you want to change all the passwords in one shot rather doing it manually for every sheet, which might be very bad way...
Download Link:WordMerger If you want to combine or merger many word document into one file and you don’t want to do it manually, This piece of software will allow you merge as many word...
Description: The Timer() function returns the Number of seconds and MiliSeconds since 12:00 AM. Format: Timer() Example:
WeekDay() Description: The WeekDay function takes Date as a parameter and returns a number between 1 and 7, that is the week day of the date provided. Format: WeekDay (strDate [Firstdayofweek]) Arguments: strDate Mandatory...
This tutorial will teach you how to get all the working days or weekdays in a specified date range(excluding Satudays and Sundays), simple but very useful when you have come up with a excel...
User Forms are one of the very important features in Excel Macro. It provides and an interface to the user for interaction with the workbook. It has many controls which makes user’s life easy...
Microsoft Excel has lot of built in formulas like Sin(), Avg() and many more, which we discuss in detail in future articles, but apart from that you can write your own functions which will...
Description: The Application.Wait () function pauses the running code or macro for the time specified and once that time is passed, it returns True value. Format: Expression.Wait (Time) Expression : A variable that represents...
Description: The DateDiff() function returns the specified time interval difference between the two dates provided. Format: DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]]) Arguments: interval Mandatory Type: String expression The time interval you want the difference between two dates.
Date() Description: The Date() function returns a Current system date. Format: Date()
To Add or Insert Multiple objects from a folder in Microsoft Excel, you need to follow the steps below: Create the object of FileSystemObject(Link) Create Folder object using FileSystemObject and GetFolder (link) method and...
Description: Filter() Function returns one dimensional array containing the filtered array elements based upon the filter options provided Format: Filter(arrArrayName,FilterValue [, Include[, vbCompare]]) Arguments: arrArrayName Mandatory Type: Array Array which needs to be filtered
Description: Join () Function returns a String that consist of array elements separated by the delimiter provided. Format: Join(arrArrayName[,delimiter]) Arguments: arrArrayName Mandatory Type: Array Array Name which needs to be converted into string.
Description: IsArray() Function determines whether the specified variable is array or not and based upon that returns the Boolean value. Format: IsArray(varVariable) Arguments: varVariable Mandatory IsArray() function evaluates this string.
Description: LBound and UBound() Functions returns the starting index ( Lower Bound) and Ending index (Upper Bound) of an array. Format: LBound(arrArrayName [, dimension]) UBound(arrArrayName [, dimension]) Arguments: arrArrayName Mandatory Type: Array Array...
Description: You can create an array using Array() function. You need to provide all the elements which you want in an array inside Array() and store it in a variable and that variable will...
You can fill a range values from an excel work book into a two dimensional array. All you have to do is assign range values to a variable and then that variable will become...