Glad it worked out.

"QTE <" wrote:

Hi Dave,

A huge thank you: all your time and effort greatly appreciated.
Thank you for correcting my improper usage of Object when declaring the
Worksheet variable: it was part of the problem.

The testme2 procedure works brilliantly. As suggested, I first tried
it without the autofilter routine: no problems. I then added the
autofilter routine and is working fine.

Thank you for explaining posting from MSP77079. Very helpful comments.
I learnt a lot.

All is well..... for now!

My reference to "Database" was made on the understanding that Excel
automatically creates a hidden named range called _FilterDatabase when
AutoFilter is on. So, I thought I'd play with it, to see what it can
do. Sometimes I come unstuck. A Little knowledge can be a dangerous
thing but then its good to try things out in a controlled, test
environment.

My information pertaining to "Database" came from a Microsoft Knowlegde
Base Article on Autofiltering:
http://msdn.microsoft.com/library/en...Autofilter.asp

As a separate issue: I wanted to see what the effect would be when
using "Database" as a workaround to prevent Empty Advanced Filter
Criteria Range or List Range Box by Naming and Defining my List Range
as "Database".

Kind regards
QTE

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

--

Dave Peterson