Filtering List by Values Using Simple Arithmetic

[rastawolf]

Hi Everyone,

First off, I am new to this forum so I would like to say hello and thank all in advance for this active community.

I am a novice coder so apologies in advance if my questions are very basic.

The below code is my attempt to filter a list based on Month and Year.
Field 2 is Months column and it filters as intended, based on a dropdown list in Range "B7".

Field 1 is where I continuously keep running into problems.
My intention is to filter the list, showing only data from the most recent 3 years based on Range "B6".

I have confirmed the array is populating accurately with the intended years, however the list is not being filtered properly.
The list disappears suggesting it is filtering by invalid data.

What am I missing here?

Thank you

Please Login or Register  to view this content.

[XOR LX]

Hi,

Range.AutoFilter requires that the criteria be text.

You could define YearFilter as:

Please Login or Register  to view this content.

Regards

[rastawolf]

Thank you, I had a hunch this was a datatype issue, and I didn't know the built in function CStr. This will prove to be very useful going forward!

[XOR LX]

You're welcome!

Regards