Tom,

Many thanks indeed! Works very well! Simple but very effective.

This does indeed speed the code up and also cuts down greatly on th
amount of code that is needed, especially for the less experienced o
us.
I don't understand why Autofilter's don't seem to be used more in plac
of loops for simple filtering??? I know I'll certainly be looking t
see if I can use the Autofilter instead of a loop in future!

Again, many thanks for your help!

Now, if you could only help me with my 'Lookup/like values' problem!!
;-)

All the best,:

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