Unused variables (and objects) in VBA code

[Woodlander]

Hi Folks,

Is there a way to easily identify which variables and objects are not used in a module, perhaps owing to updates to the original code?

 

[YasserKhalil]

Old question. I have the same question.

 

[Fluff]

I use an add-in called MZ Tools which can do that & I suspect there are other add-ins that can do the same.
Other than that if you use Option Explicit, you can comment out all the variables & then debug the code to see which variables are needed.

 

[RoryA]

Also posted here: www.eileenslounge.com/viewtopic.php?f=30&p=270103