View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default How to find all UDF calls in all workbooks

Try Find, FindAll with "myFunc("

Ensure Match Entire cell is not checked and Look in: Formulas

Could write a macro to return a list of all found in each sheet. You would
need to open the workbook though.

Regards,
Peter T

"Prof Wonmug" wrote in message
...
I've decided to make a few "improvements" to some of the UDFs in my
personal add-in module. Now I need to find all of the calls to those
UDFs in all of my workbooks, because the syntax has changed some.

Is there an easy way to find them other than opening each one?