VBA RIGHT Function (Syntax + Example)

puneet-gogia-excel-champs

- Written by Puneet (Last Updated: June 22, 2023)

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.

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 the VBA RIGHT function, you need to go through the below example where we have written a vba code by using it:

example-vba-right-function
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.

Last Updated: June 22, 2023