what do you mean bye debug your code properly ? the combobox has the worksheets that are in the excel file and no i'm not opening the wrong file . sorry if i offended you but what you're suggestion is just not logical for me sorry again