AutoFilter Percent Values +-5%

[Paul_Hossler]

Paul, post 31, "Set wb2 = Workbooks("Book2.xlsx")", both workbooks are .xlsm and can't be changed. I tried with .xlsx but no difference. I tried your code but I get same result as before = filtered but doesn't show until I click the OK button. I also tried with "ThisWorkbook"

xlsx or xlsm doesn't make any difference. Still works just fine without having to hit OK.

What are you regional settings? Possible there's a conflict so 39,5 would be a string and wouldn't work with numbers

I vaguely recall that Filter Criteria only works with US Dates and US Number formats

So if I open a Swedish formatted workbook with a number format 123,45 Excel converts it to 123.45 for my US format