VBA Code to show autofilter criteria just show result as <>, even though filter is set

Hi!

I have used the below code for a while, but a few days ago it suddenly stopped working. Can anybody please help me with a solution for this? It's not working on any computer it's tested on.

Please Login or Register  to view this content.

Where I want to use it in the Excel-file, I use "=DispCriteria(A31)" to get the filter criteria. But a few days ago it just started to show me the result <> in that cell. Anyone that can help a lost noob? Hehe

EDIT: Also posted on: https://www.mrexcel.com/forum/excel-...ilter-set.html

Best regards

Barebells

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #8 about cross-posting and adjust accordingly...
• Also see, A message to forum cross posters