Excel / VBA Chr function
Chr is a Text function in Excel that we may use in the VBA.
VBA Excel
VBA Replace Function
VBA Replace function is used to replace a given substring (expression) in the source string.
Delete Excel Range Values/Formulas by VBA ClearContents
The ClearContents is an Excel function that can be used in VBA to remove values and formulas in range.
VBA InStrRev Function
The Excel/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.
VBA Sum Function [Ranges, Variables, Numbers]
The Excel SUM function can be used in VBA by WorksheetFunction object.
VBA IsNumeric Vs IsNumber [Compared with 4 Examples]
IsNumeric is the VBA function that you may use directly. IsNumber is the Excel function that you may use in VBA. However, you have to use this with Application.WorksheetFunction object.
Excel / VBA CountIf Method with 7 Examples
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.
VBA Max Function
The Max() is WorksheetFunction that you may use in the VBA coding to get the maximum number.
It takes up to thirty arguments i.e.
4 Examples to Learn VBA Mod Operator
To get the remainder of a division, you may use the Excel/VBA Mod operator.
VBA UBound and LBound Functions
UBound and LBound are array functions in VBA. Let us look at these, one by one.
Excel/VBA Now() function: Get Current Date and Time
The Now() function returns the current date and time from the computer system. It returns variant (Date).
VBA Integer Vs Long Data Types: Explained with 6 Examples
In VBA, there are a few numeric data types that you may use to handle numbers in your applications. Out of these, Integer and Long deal with signed numbers.
6 Examples to Understand VBA Equal and Not Equal to Operators
Equal to and Not Equal to are comparison operators in VBA. Used to check or compare values, let us take a look with examples one by one.
Excel/VBA Mid function [4 Examples – simple/Range]
If you require a substring from a given string, use the Mid function. You may specify the number of characters to start form in the given string in the Mid function.
Perform Case-Sensitive Search by VBA Find MatchCase – 2 Examples
How to perform a case-sensitive search using VBA Find function. We have shown examples of using “What” and “After” arguments in this VBA Find tutorial.
