| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the other workbooks name | Excel Programming | |||
| Subroutine calls between workbooks and object references | Excel Programming | |||
| find and replace in workbooks | New Users to Excel | |||
| find same amount in different workbooks | Excel Worksheet Functions | |||
| using find in 2 or 3 workbooks that are open | Excel Discussion (Misc queries) | |||
Threaded Mode
