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
Bookmarks