sheets and cells

Nested If Statement An If or ElseIf statement inside another If or ElseIf statement. The inner If statements execution is based on…

VBA Len Function What if you are given the sentence “Hello World, VBA is an Excellent Language!!” and you are asked to…

VBA Do While Loop The Do While Loop is used when we want to repeat a set of statements as long as…

VBA Option Explicit “The VBA Option Explicit statement is used to declare the variables mandatory while writing codes. It is a secure…

VBA Editor The first step to working with VBA in excel is familiarized with the Visual Basic Editor also called the VBA…

VBA Right Function Excel provides many inbuilt text functions that helps the users to deal with text-based data. Some of these functions…

VBA Error Handling The VBA code is usually prone to errors, the developer can always make mistakes whether its syntaxial or logically.…

VBA Select Case VBA Select Case statement is used instead of multiple Nested If statements. The VBA Select Case makes the VBA…

VBA For Each Loop For Each loop is used to execute a statement or group of statements for each element in an…

VBA Split Function When working with VBA Excel, the user may often require splitting a string into substrings based on a given…