Hi

I have 250 sheets, I'd like to attach 2 macros to 2 buttons.
One to find the extact value of the active cell,
One to search forward and One to search back
and to stop when at the end or beginning or of sheets.

Thanks In Advance

Dave

the built in find can do that already .... just change worksheet to workbook
under the Options button


"Dave" wrote in message
. uk...
Hi

I have 250 sheets, I'd like to attach 2 macros to 2 buttons.
One to find the extact value of the active cell,
One to search forward and One to search back
and to stop when at the end or beginning or of sheets.

Thanks In Advance

Dave