VBA

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.

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.

Chr is a Text function in Excel that we may use in the VBA. Learn how to use Chr function with examples in our tutorial.

The ClearContents is an Excel function that can be used in VBA to remove values and formulas in range. Learn how to use it!

The Excel SUM function can be used in VBA by WorksheetFunction object. In this tutorial, we will shows you how to use it in VBA with output.

The COUNTIF is an Excel function that you may use in VBA as well. For that, you may use the WorksheetFunction object’s CountIf method.

IsNumeric is the VBA function that you may use directly. IsNumber is the Excel function that you may use in VBA.

To get the remainder of a division, you may use the VBA Mod operator. In this tutorial, we will show how to use Mod with examples.

Mid function is used if you require a substring from a given string. Learn how to extract substrings at jquery-az.com.

UBound and LBound are array functions in VBA. Let us look at these, one by one with examples in our tutorial @ jQuery-az.com

VBA Now() function returns the current date and time from the computer system. It returns variant (Date). Learn with examples!

In VBA, there are a few numeric data types that you may use to handle numbers. Out of these, Integer and Long deal with signed numbers.

Equal to and Not Equal to are comparison operators in VBA. These are used to check or compare values. Learn how in this tutorial.

How to perform a case-sensitive search using VBA Find function. In this tutorial, we will show how to use MatchCase in the Find function.

By using VBA Columns property, you may Hide/unhide columns in the Excel sheet, Delete specified columns and do more.