ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Finding Unreferenced Subs and Functions (https://www.excelbanter.com/excel-programming/356975-finding-unreferenced-subs-functions.html)

Josh Sale

Finding Unreferenced Subs and Functions
 
I have a fairly large add-in that has had a lot of people's hands in it. I
was wondering if anybody knew of a utility that would analyze the add-in to
try and find unreferenced Subs and Functions?

I say "try" because I understand that the kind of static analysis such a
utility would perform would necessarily be imperfect. Still I would love to
have the recommendations from such a utility to guide my cleanup effort.

TIA,

josh



Zack Barresse[_3_]

Finding Unreferenced Subs and Functions
 
Hi there,

Check out M-Z Tools. It will find unused variables and such and it will
give you listings of unused procedures. From the VBE, Tools | MZ Tools |
Other Utilities | Review Source Code.

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Josh Sale" <jsale@tril dot cod wrote in message
...
I have a fairly large add-in that has had a lot of people's hands in it. I
was wondering if anybody knew of a utility that would analyze the add-in to
try and find unreferenced Subs and Functions?

I say "try" because I understand that the kind of static analysis such a
utility would perform would necessarily be imperfect. Still I would love
to have the recommendations from such a utility to guide my cleanup
effort.

TIA,

josh




Zack Barresse[_3_]

Finding Unreferenced Subs and Functions
 
Also, beware when it says a procedure is unused. If the procedure is called
via string syntax, i.e. Application.Run method, then it will not pick it up.

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Josh Sale" <jsale@tril dot cod wrote in message
...
I have a fairly large add-in that has had a lot of people's hands in it. I
was wondering if anybody knew of a utility that would analyze the add-in to
try and find unreferenced Subs and Functions?

I say "try" because I understand that the kind of static analysis such a
utility would perform would necessarily be imperfect. Still I would love
to have the recommendations from such a utility to guide my cleanup
effort.

TIA,

josh





All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com