Hello everyone

I am currently imvolved in a large project, that started off as a very
small project, just a few lines of code, that has mushroomed to over a
thousand. I have not declared variables in this project, but would now
like to, but the problem is there are dozens, if not hundreds. Is there
a quick way for me to see/list all the variables so I know what they all
are and can start declaring them?

Secondly, can anyone tell me what is the benefit (if any) of
"compiling" the code (Debug ... Compile VBA Project) before I save it,
because it does appear to increase the file size, but does it offer any
benefits??

Thanks for reading

DJB


--
DJB
------------------------------------------------------------------------
DJB's Profile: http://www.excelforum.com/member.php...o&userid=21221
View this thread: http://www.excelforum.com/showthread...hreadid=384286