Hi,

I am looking for a way to search through a certain cell on multiple
worksheets, for example: B5 on Sheet 3 through Sheet 45, and when the
cell has a number in it (it is either going to be blank or have a
number), a message box pops up displaying the worksheet name. I want
to insert a button or something that the user can press to start the
search, then the user will input the cell to search in and the program
will run, displaying message boxes for every worksheet that has a
number (only a few will). I would be very very grateful for any help
with this!

Thanks,
-Steve


--
thephoenix12
------------------------------------------------------------------------
thephoenix12's Profile: http://www.excelforum.com/member.php...o&userid=24336
View this thread: http://www.excelforum.com/showthread...hreadid=380524