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 the RIGHT function in the worksheet.
- Str: The string from which you want to extract a sub-string.
- Length: The integer to specify the length of the sub-string.
To practically understand how to use the 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.