I am trying to write a macro to help me in my filtering of a list of
data. I have a list of references and I need to filter the list of
references according to the following criteria:

1) Starts with 325 and
2) last three digits =100 AND <150, OR last three digits =250 AND
<300

My list of references looks like this:
3513338009
3513338032
3883338008
3953338166
3953338167
3953338171
3953338274
3193338861
...

I tried to use the excel function [=right()] but however, this function
returns a text and I am unable to filter my list according to my
criterial. Can anyone help me on this? thanks!


---
Message posted from http://www.ExcelForum.com/