Thank you for all the help guys ... the autofilter functions are not
particullarly straight forward to understand, but I did find an
excellent resource on their use ...
http://www.contextures.com/xlautofilter03.html
Runs throught pretty much everything you want to use them for. I've
fixed the problem using this resources as a guide. The
VB Help files
actually say that you cannot set AutoFilterMode to True, only False?
--
CFD
------------------------------------------------------------------------
CFD's Profile:
http://www.excelforum.com/member.php...o&userid=27306
View this thread:
http://www.excelforum.com/showthread...hreadid=476079