VBA RIGHT Function (Syntax + Example)

The VBA RIGHT function is listed under the text category of VBA functions. When you use it in a VBA code, it returns a sub-string from a string from the ending position. In simple words, you can extract a number of characters from a string from it is ending, which is the right side. It simply works like RIGHT function in the worksheet.

Syntax

Right(Str, Length)

Arguments

  • Str: The string from which you want to extract a sub-string.
  • Length: The integer to specify the length of the sub-string.

Example

To practically understand how to use VBA RIGHT function, you need to go through the below example where we have written a vba code by using it:

Sub example_RIGHT()
Range("B1").Value = Right(Range("A1"), 6)    
End Sub

In the above code, we have used RIGHT to get the 6 characters from the right side of cell A1 (Excel Champs) and get it in cell B1. It has returned the value (Champs) in the result as these are the first 6 characters we have in cell A1.

Related Functions

FORMAT | INSTR | INSTRREV | LCASE | LEFT | LEN | LTRIM | MID | REPLACE | RTRIM | SPACE | STRCOMP | STRCONV | STRING | STRREVERSE | TRIM | UCASE