Friday, July 22, 2016

Excel Macro To Search Entire Workbook

         With Vba ,it is possible to search an entire workbook, for a searched value. 

We will use The Find Method for this process.In Excel Program, The Find & FindNext Method is a very powerful option in finding data  and is useful.

          When the macro runs , inputbox opens and asks the data we want to find. The found results are listed on the MsgBox  with cell addresses. The process continues until user  stops it.


No comments:

Post a Comment