Find value of cell in other sheets

D

Dave

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
 
P

Patrick Molloy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re-Post Find value of cell in another sheet 2
Word macro that can call cells out of Excel for a find and replace 0
Find the correct sheet then find a value on that sheet 8
Word VBA - Want to test if Full Name is NOT Present in document 0
External cell reference between two excel worksheets both in One Drive 0
VBA dropdownlist to put in cell's comment creates runtime error whenthe dropdownlist is above 266 li 0
Macro to Combine Data from Multiple Sheets with Cell References 4
VBA for Dependents shortcut menu 0

Top