Hi All,

I have a workbook with several sheets.
Column (J2:J65536.end(xlup))is named as RecNo except in
the first two and last two sheets.
I want to search all sheets except the first two sheets
and last two sheets for a value in combobox1 in userform1
and if found i want to add the sheet name (s) in listbox1

How can I accoplish this

Thanks in advance
Soniya