Expanding Search Engine in Macro Excel

[UWS2012]

I'm currently working from a macro template that has a search feature that is limited to Columns A and B. I would like to expand the search function to range from A through F but cannot format the code correctly. I've attached the template below -- thanks in advance!

[AB33]

This code is written By leigh Ross in response to the same question and the same code.

Please Login or Register  to view this content.

[UWS2012]

This is helpful, however I can't seem to get the search function to work properly. I simply pasted the above code in Module 1 (General) -- is that the right move?

Thanks!

[AB33]

Slightly amended the code. Try the attached

[UWS2012]

Thanks -- I see your adjustments and agree with them. However, Excel 2010 is still coming up with an error message that reads "Cannot run the macro "Searchable Macro (1).xlsm'!SearchParts'. The macro may not be available in this workbook or all macros may be disabled."

I've ensured that the macros are enabled so I'm not exactly sure what's the problem. This attached file thought is exactly what I'm looking for.

[AB33]

I have now save it as excel 2003 version. See post #4

[UWS2012]

I just upgraded to 2010 to open the original file and it still didn't work. Any other suggestions?

[AB33]

I do not know. You have already a code on your module. If that code is working, replace it with the new code. I have tested it and is working on the attached.

[UWS2012]

I took your advice and worked off the current formula and was able to search two additional columns. If anyone can help me pick up the fifth column titled "Notes" in this search matrix it would be a great help. Here's the updated file:Searchable Macro.xlsm