I need to design a macro which will basically automate the "Find All" function so that other users can perform a search on a sheet.
e.g. equivalent to going Edit, Find, "search term", Find All, and then being able to click on the desired result from the list displayed and be taken to that cell.
I've spent about 4 hrs getting nowhere with this - when I try to record a macro of myself performing this action using Edit,Find the macro is blank and contains no code at all. If I record using "Find Next" instead of Find All, there is code but a) it doesn't actually execute and take you to the cell when you run it by macro and b) I really need the list of results that users can choose from.
Any help greatly appreciated...