I do a lot of web design using Dreamweaver. Since a website may contain many
web pages, there is a neat feature that lets me check for unused (or,
unlinked) pages.

I was wondering if there weren't a set of programmer's utilities for Excel
VBA that would do something similar.

For example, if I declared a variable, but that variable was never used
anywhere, the utility would notify me of that.

Or, give me a list of all variables (including type, scope & values for
constants) and the macros they were declared or used in.

It's been a long time since I did much programming, but I remember having
these types of utilities and was just looking for suggestions.



Thanks,

Ken Loomis