What excel version are you using?
97 had a bug using find across worksheets otherwise just group the sheets
before you do the find (click one sheet, hold down shift and click the last
sheet or hold down ctrl and select each sheet you want to include)


Regards,

Peo Sjoblom

"Sholtzy" wrote:

I can get it to search for items on one sheet but I need to look through the
whole notebook.