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
|