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.
The Find function has various arguments (required/optional), our focus for this tutorial is using “What” and “After” arguments.
Excel rows can be deleted by using Delete method in VBA. You may specify WorkSheets.Rows.Delete method to remove one or more rows
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.
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
You may use Borders.ColorIndex property to set the border color from available 56 color palette
Hiding columns in VBA By using Worksheet’s Columns property, you may hide one or more…
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
For one dimensional array, you may get the array length (size) by using UBound function.
How to create arrays in VBA by using different ways. Accessing array elements by index. One-dimensional and two definitional arrays (using Excel Sheet)
Basically, Not operator negates the given condition. It is used to reverse the result of a condition or expression.
The interior (background) color of the cells in the Excel sheet can be set by using the VBA ColorIndex property.
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).
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.
In VBA, a newline can be added by using following: vbNewLine constant vbCrLf constant vbCr constant