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.
VBA Excel
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.
Excel/VBA Columns Property: Explained with 6 Examples
By using Columns property, you may: Hide/unhide columns in the Excel sheet Delete specified columns Change the interior color of an entire column or in the range
VBA Trim, LTrim and RTrim for Removing spaces
VBA has a few string functions that is used to remove spaces in strings, or cells of an Excel sheet.
VBA Multi/Two-Dimensional Arrays with 4 Examples
A two-dimensional array in VBA can be created as follows: Dim arr_2D(1 To 6, 1 To 3) As String
VBA Rnd, RandBetween to Generate Random Numbers [1 to 10, 1 to 1000]
You may use built-in functions in VBA to generate random numbers. The first function is Rnd().
5 Examples to Set Excel Cell, Rows, Cols Font Color in VBA
In this tutorial, we will show you how to set font color in Excel sheet cells, rows, and columns by using the range object’s Font property.
VBA IsEmpty Function
What is VBA IsEmpty function? The IsEmpty function is used to check if a cell…
VBA LOOKUP function: Explained with 5 Examples
VLOOKUP function is used to find things in an Excel sheet (table or range) by row. Basically, VLOOKUP is a sheet function but you may use it in VBA as well.
Handling Excel VLOOKUP Errors (N/A & Value)
The #N/A error occurs when a given value is not found as using the Excel VLOOKUP function.
VBA InStr Function: 7 Simple and Excel Sheet Examples
InStr is a text/string function that is used to search in a string. It returns (as Variant/Long ) the first occurrence of the searched text/string.
How to Search Excel Range and Format by VBA InStr/EntireRow
In this short tutorial, we will show you how to search text in Excel Ranges (Cells, Rows), etc., and then format entire rows.
Excel/VBA Range Select Method
In the selected cells, you may perform various tasks e.g. setting the font name, making it bold/italic, etc., setting the background color of the selection and others.
