Trouble with Advanced Filter

R

Rach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top