Looking for an equivalent of RIGHT function in VBA

I am using vCriteria to create a scripting dictionary, but rather than the criteria being based on a the entire contents of a cell I would like to use an equivalent of the RIGHT function.

So at the moment my criteria is for the entire contents of cell D5:

vCriteria = Sheets("Sheet1").Range("D5").Value2


But I don't want to use all of the contents I would like excel to not include the last four characters as part of the criteria, i.e. an equivalent of =RIGHT(D5,4)

Is this possible in VBA?

Thanks in advance

oh well I meant to put include, sorry about that just a bit of a slip up

thanks for your help