psionic
11-10-2007, 04:35 AM
Hi again :hi: Experts (so I hear others say).
I have come across a situation while using the Excel Autofilter Custom in Excel 2002 where you select these range of options to choose from.
When I use the "contains" selection and specify 1
I will get a list of entries that contains anything with a "1" in it. That is no problem.
Is it possible to do this with a range of numbers like 0-9 ?
In other words instead of repeating these steps for each number can we do this similar to the VBA like [0-9] thing?
It does really matter if we can't do this but I am curious would it work?
Thanks and warm regards,
Psionic
I have come across a situation while using the Excel Autofilter Custom in Excel 2002 where you select these range of options to choose from.
When I use the "contains" selection and specify 1
I will get a list of entries that contains anything with a "1" in it. That is no problem.
Is it possible to do this with a range of numbers like 0-9 ?
In other words instead of repeating these steps for each number can we do this similar to the VBA like [0-9] thing?
It does really matter if we can't do this but I am curious would it work?
Thanks and warm regards,
Psionic