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

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.

try Jan Karel Pieterse's FlexFind.

You can find it he
http://www.oaltd.co.uk/MVP/

It'll work with all versions.

Sholtzy wrote:

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

--

Dave Peterson