I apologize for the the first post, the spelling and not explaining
properly.

Has been a busy day.

Hi

I have about 250 sheets, I'd like to attach 2 macros to 2 buttons."I can do
that"
To find the value of the active cell,
One to search forward "searching in sheets left to right" and one to search
right to left "sheet by sheet"
and for it to stop at the end, meaning if the last cell value is found in
sheet 210 it does not loop and start say sheet 7 were it started.

Thanks In Advance

all the best

Dave