Filter Using Exact Match

[biocentrism]

Hello

I am trying to filter an array for an "exact" match using the following code.

The problem I am running into is that it is calling a match if it finds "1" when searching for "11".

Is there a way to alter the code such that 1 does not return as a match for "11".

Thank you.

arrMonthsFiltered = Filter(arrMonths, CStr(TradeMonth), vbTextCompare)

 

[JoeMo]

You are missing an argument in the filter function which requires another comma (in red font below):

arrMonthsFiltered = Filter(arrMonths, CStr(TradeMonth),, vbTextCompare)