Download MZ-Tools, it has a facility to analyze a project and it tells you
that. It is free.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jeff" wrote in message
...
Hi,

I have a few macros that are being edited.
My question - is there a way to tell if a declared variable
has been used in the "sub Marcro()" or if it was just declared (i.e. dim
Variable3 as double) and not used.

This would be useful because it would allow me to more easily delete
unused
variables and eliminate clutter.

Thanks