I created a mini search engine. The routine allows the user to input data in cell B3 on the "List" tab so that when he/she hits the search button a list of matches generate. The list of matches are based on column A of the "Data" tab.
While the code works just fine, the problem I am having is using named ranges. I would like to reference the named ranges in my code instead of using regular column/row syntax.
If you open up my excel spreadsheet you will see my attempts to change the syntax to named ranges indicated by the comments just so you can compare the code that works to the code that doesn't.
I only have three named ranges which are all part of the data tab. Column A is "NM" (where it searches for the match), Column B is "DESC", and Column C is "NM_DESC".
I can't seem to make it work when it comes to the loop statement. I've tried several different ways and it always comes up as an error. Any help would be appreciated!
Bookmarks