4 Examples to Learn Excel / VBA DateDiff Function
The DateDiff function in VBA is used to calculate the difference between two dates – in terms of days, years, months, quarters, hours, minutes, etc – depending on your requirements.
VBA Excel
How to Get Length of String by VBA Len function?
To get the length of a string, value in the cell, etc., you may use the Len function in VBA.
How to Close Excel Workbook using VBA Code
In this tutorial, we will show you the code for closing the Excel Workbook using VBA. For closing a workbook, you may use the Close method of the Workbook object.
How to Create New Excel Workbook using VBA
For creating a new Excel Workbook, you may use the Workbooks object’s Add method in VBA.
VBA Round Vs RoundUp Vs RoundDown
If you are using Excel directly then it has a few functions to round numbers. These are:ROUND ROUNDUP ROUNDDOWN MROUND
Excel/VBA Right Function
The Right function returns specified numbers of characters from the right of the string.
It takes two arguments – both are required:
Excel / VBA PasteSpecial Method: Explained with 3 Examples
PasteSpecial function in VBA Normally, as you copy/paste a cell or range of cells in…
Excel / VBA IIf Function: Explained with 3 Examples
The IIf function (capital II and small f) can be taken as a simple form of If..Then..Else statements.
2 Examples to use VBA CDate function
The CDate function converts an expression to date type.
Excel / VBA Autofill Method
AutoFill is a pretty useful method in VBA that can be used to auto fill the cells in the specified range.
How to Comment Single Line/Block in Excel / VBA
In VBA, you may add single line comments or block (multiple line comments) by using:
Single quote for single comment
Using the menu option for block of comments
Excel/VBA Weekday Function
The Weekday function returns the number of day of the Week for the given date.
Excel / VBA Date Function with 7 Formatting Examples
VBA Date function returns the current date of the system. It can be used with the format function to get the date in the desired format. We will show this in examples.
3 Examples to Understand VBA If Or Operator
The Or operator in VBA is used to check multiple conditions. If any of the conditions is True, the code inside the If statement executes.
3 Ways of Copy/Paste Value, Formatting, Formulas in VBA / Excel
The Range object in VBA has copy method that can be used to copy/paste the contents from one cell or range of cells to other cells.
