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.
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.
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.
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.
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.
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 has a few string functions that is used to remove spaces in strings, or cells of an Excel sheet.
A two-dimensional array in VBA can be created as follows: Dim arr_2D(1 To 6, 1 To 3) As String
You may use built-in functions in VBA to generate random numbers. The first function is Rnd().
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.
What is VBA IsEmpty function? The IsEmpty function is used to check if a cell…
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.
The #N/A error occurs when a given value is not found as using the Excel VLOOKUP function.
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.
In this short tutorial, we will show you how to search text in Excel Ranges (Cells, Rows), etc., and then format entire rows.
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.