VBA Right Function – How to use Right

Published by admin on

1. Right VBA Function – Description

The VBA RIGHT function in Excel return a specified number of characters from the text, begining from the right side. It can be compared to the RIGHT function in Excel worksheet. How does the RIGHT function work? The function return text from another text starting from the right side. For example, from the sentence “I’m the best programmer” we can return word “programmer”.

2. VBA Right Function – Syntax

String – The text string from which we cut text from the right side.

Length – We can specify in this argument how many characters from the string we want to return.

Function returns: String / text value

3. Right VBA Example

Here is an example of using the RIGHT function in the VisualBasic Editor. You can paste it into Code window.

VBA Functions - VBA Right Function

VBA Functions – VBA Right Function

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: