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 Loops There is a situation when you need to execute a block of code several numbers of times. In general, statements…

What is Macros? A Macros is a piece of programming code that runs in excel environment, and it helps to automate routine…

VBA Date Format The Date Format function takes a date expression, and it returns a string containing an expression formatted according to…

VBA-M VBA-M is a fork of the inactive VisualBoy Advance project. It improves the capabilities and features of the emulator. VisualBoy Advance…

VBA Dim VBA Dim is a keyword that is used for the word dimension. It is also used to declare variable names…

VBA MID Function There arise many situations in day-to-day Excel life where we want to fetch the first substring, last substring, or…

VBA Do Until Loop The Do Until Loop is used when we want to repeat a block of code or a set…

VBA MsgBox The MsgBox is a dialog box in the excel VBA that can be used to inform the users of your…