Set the Border Color of Excel Cells by VBA Color/ColorIndex Properties
You may use Borders.ColorIndex property to set the border color from available 56 color palette
VBA Excel
How to hide Excel Sheet Columns in VBA
Hiding columns in VBA By using Worksheet’s Columns property, you may hide one or more…
VBA Rows Property – Access Single/Multiple by Range
To select a row in an Excel sheet, you may use the Range object Rows property. You may select one or more rows by using the Rows property
5 Examples of How to get Array Length/Size in VBA
For one dimensional array, you may get the array length (size) by using UBound function.
How to Create and Access Arrays in Excel VBA
How to create arrays in VBA by using different ways. Accessing array elements by index. One-dimensional and two definitional arrays (using Excel Sheet)
VBA If..Not (Logical Operator): Explained with 2 Examples
Basically, Not operator negates the given condition. It is used to reverse the result of a condition or expression.
Excel/VBA Interior/Background Color by ColorIndex/Color
The interior (background) color of the cells in the Excel sheet can be set by using the VBA ColorIndex property.
4 Examples as Solution to VBA Continue Statement
As we know, VBA has “Exit For”, “Exit Do” to come out of the loop entirely – which is achieved by the break statement (normally in other programming languages).
VBA break is Available? How to Exit For Loop?
In programming languages, there is normally a break statement is available to exit a loop (For, While, Do While) while it is still not completed. There is no break statement in VBA.
5 Ways of Adding newline in VBA (Carriage Return)
In VBA, a newline can be added by using following: vbNewLine constant vbCrLf constant vbCr constant
4 Examples to Understand VBA For Each Loop [Cells, Arrays]
The For..Each is a loop type in VBA. This loop is used to execute one or more statements for arrays or collections
How to Concatenate Strings, Integers, Variables, Cells in VBA
In VBA, you may concatenate values, strings, variables, and Excel data by using the ‘&’ operator.
VBA If Statement with And Operator [4 Examples]
VBA If..And statement is used when you have to test multiple conditions to execute one or more statements.
8 Examples to Add Sheet in Excel by VBA
A new sheet can be added by Sheets object’s Add method. For example,
Sheets.Add
This code will add a sheet before the active sheet in your Workbook.
Excel/VBA Active sheet: Learn to Access, Rename, Activate with 4 Examples
In this tutorial, how to make a non-active sheet in Excel an active sheet by using VBA code.
