yeah thats done it, i also turned off autofilter if theres no result s
it displays the whole list again without having to go back to sho
all.

thank

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