please help both of us as i am also stuck with this Procedurein my case i had different sheet in a xls file as there are limitation of autofilter . i want to developed one formfor searching and displaying the corresponding value in the the form