LOL I just realised i was using the wrong list data, its working now.

one thing i noticed even on the working one is that the autofilte
dropdowns keep appearing on the columns even though it appears you
code should turn them off which is strange. any ideas why or how
might stop that?

Thank

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