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 Excel
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.
4 Examples of Excel/VBA Find with What & After Arguments
The Find function has various arguments (required/optional), our focus for this tutorial is using “What” and “After” arguments.
How to Remove Single/Multiple Rows by Delete method in VBA
Excel rows can be deleted by using Delete method in VBA. You may specify WorkSheets.Rows.Delete method to remove one or more rows
Excel/VBA Range [11 Examples]
VBA has a Range object that can be used to select the range of cells in an Excel sheet. You may use Range object to get the cell’s value.
5 Examples to use Excel/VBA InputBox
InputBox:is a function in VBA i.e. used to display a textbox field/prompt to the user to take input. It Returns a string as user clicks the “Ok” button or press enter
