Gringoire
Board Regular
- Joined
- Nov 18, 2016
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
Hello friends, I have a strange issue with autofilter: in the picture below you can see a part of a large table where I need to filter on the column 6 using a wildcard.
Everything goes fine with letters but not with numbers:
this code works perfectly:
This code instead does not catch any row:
I tested the code with number formatted as numbers or text but it makes no difference...
Any hint?
Thank you in advance.
Everything goes fine with letters but not with numbers:
this code works perfectly:
VBA Code:
ActiveSheet.ListObjects("TabRawData").Range.AutoFilter Field:=6, Criteria1:="TV*", Operator:=xlFilterValues
This code instead does not catch any row:
VBA Code:
ActiveSheet.ListObjects("TabRawData").Range.AutoFilter Field:=6, Criteria1:="23*", Operator:=xlFilterValues
I tested the code with number formatted as numbers or text but it makes no difference...
Any hint?
Thank you in advance.