## VBA IsNumeric Vs IsNumber

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

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.

VBA InStrRev function (In String Reverse), is just like the InStr function except for it searches the given term from the end of given string.

In VBA, you may get today’s date by: 1- Using Date() function 2- Now() function. Learn how to use these functions with examples.

VBA has a few string functions that is used to remove spaces in strings, or cells of an Excel sheet. Understand how in this tutorial.

VBA Replace function is used to replace a given substring (expression) in the source string.

A two-dimensional array in VBA can be created as follows: Dim arr_2D(1 To 6, 1 To 3) As String. Understand using this with examples!

You may use built-in functions in VBA to generate random numbers. The first function is Rnd(). Learn more about this…