Saturday, January 16, 2010

How do you add a search document button or a ';Control F'; shortcut to a cell in an Excel Workbook?

Using functions, like FIND or SEARCH.


In a cell (Say B2) paste this


=FIND( ';What';, A2)


Assuming you want to search for the text ';What'; that can be found in cell A2





If you want t osearch for a value in more that one cell, that is another issue, mail me here





Enjoy my profile, I am the VBAXLMan

No comments:

Post a Comment