Unused Variable Analysis

The Unused Variable Analysis feature in Total Visual CodeTools helps you detect and eliminate unnecessary code from your VB6 and VBA projects including Microsoft Access, Excel, Word, etc. Quickly find code that's defined but never referenced or used. This includes:

• Unused variables defined at the procedure, module, and project/global levels through Dim, Public, and Private statements
• Unused procedure parameters
• Unused constants
• Unused classes
• Unused user defined types and their elements

Unused code commonly occurs when changing existing code or eliminating previous code without noticing the variable definition remained. You fix this by simply deleting the variable definition.

However, this can also occur when you define a variable -- especially a procedure parameter -- then forget to use it. Maybe you wanted to track something or do something special based on a value but failed to do so. Rather than simply deleting the variable, you need to determine its purpose and make sure it's no longer necessary or implement it correctly.