On Fri, 29 Oct 2004 11:28:30 -0400, "Gauthier"
wrote:

Hi Ron...fyi - i finally came up w/ a solution that works...

I changed the heading in B1 to LEN

In the source data, I added another column with the heading LEN and the
formula as directed to determine your TRUE result. I adjusted the named
range data_range_for_filter to include the extra column.

I ran the code with these modifications and it worked!

Thanks for all your help and looking at my workbook for me!

Sandi

I just thought of another possibility. Since the regions are all numeric, why
not a column called REGION in the Criteria Range, with the criteria being
<100000000 ?


--ron