How to find Excel files containing specific functions

Alan_42

New Member
Joined
Jul 1, 2021
Messages
3
I'm using Excel 2003 and Windows 10.

I have an AddIn file called MyAddIns.XLA which contains many SUBs and functions, all of which work quite well.

I also have many spreadsheets which use a variety of these SUBs and functions.

But what I didn't do, and perhaps should have done, was to keep a record of which functions are used in which spreadsheets.

This hasn't been a problem up to now, but I have made a change to a function which means I need to alter the formulas that use it.

I'm fairly sure I've managed to find most of these, but would like to be absolutely certain.

I've tried:
1. the "File Search" facility within Excel 2003 but it won't find function names within formulas.
2. the Windows 10 Search facility - same problem.
3. a third party search facility - same problem.

As an example, I have a function called "ReverseMatch" and if I just enter that as text in a cell, then all the above methods find it. But when I use it in a formula, no results are found.

Any suggestions?
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
OK - so I've done a bit of research and discovered that what I'm trying to do is, I think, impossible.

This is because Excel does not store the textual names of functions within files. It uses pointers. Well of course it does!

So - I'm going to have to go through all my files and create a record of which workbooks use which functions. A long and tedious job but worth doing.

Advice, therefore, to anyone regularly using UDFs. Keep records.

This thread is closed.
 
Upvote 0
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to find Excel files containing specific functions
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top