Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble with Advanced Filter
Hello-
I have a snippet of VBA code to perform an advanced filter that has been working like a charm for several years on a defined set of data. I have just started to use this code on a new set of data, and for some reason the value "I.3.1" will not filter. I am able to filter it using autofilter, I have confirmed that the values in the criteria range are exact, etc. Also, similar values I.3.2 work fine, I.4.1 work fine, but I.3.1 will not filter. The code Worksheets("Sheet1").Select Let lastrow = Application.CountA(ActiveSheet.Range("j:j")) + 3 Range("H5").Select Selection.CurrentRegion.Select Range("A5:H" & lastrow).AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _ Range("other") Does anyone have any ideas about why the code works for all other values except I.3.1? Thanks for your help in advance, Rachael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble with Advanced Filter
There is nothing special about "I.3.1" (I just tried it to be sure) so my
guess is that the data does not match the criterion in this case. Just to positively test this I'd suggest that you enter "I.3.1" in the criterion cell and then enter a temporary formula like =A10=F2 somewhere where A10 is a cell in the data list that has the apparent value of I.3.1 and F2 is the criterion cell. If it's False you know the data has junk like an extra space, etc., in it. -- Jim wrote in message oups.com... | Hello- | | I have a snippet of VBA code to perform an advanced filter that has | been working like a charm for several years on a defined set of data. | | I have just started to use this code on a new set of data, and for some | reason the value "I.3.1" will not filter. I am able to filter it using | autofilter, I have confirmed that the values in the criteria range are | exact, etc. Also, similar values I.3.2 work fine, I.4.1 work fine, | but I.3.1 will not filter. | | The code | Worksheets("Sheet1").Select | Let lastrow = Application.CountA(ActiveSheet.Range("j:j")) + 3 | Range("H5").Select | Selection.CurrentRegion.Select | Range("A5:H" & lastrow).AdvancedFilter Action:=xlFilterInPlace, | CriteriaRange:= _ | Range("other") | | Does anyone have any ideas about why the code works for all other | values except I.3.1? | | Thanks for your help in advance, | | Rachael | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with Advanced Filter | Excel Discussion (Misc queries) | |||
trouble with advanced filter | Excel Discussion (Misc queries) | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |