There is no quick way to see a list of all of the variables. The compiler
will not make that distinction until run time when it will create all of your
variables on the fly. I am with Rich... Add the Option Explicit and then hit
Debug - Compile. On the up side you learned to alway declare you variables
even in small projects. It is a good thing to learn.
--
HTH...

Jim Thomlinson


"DJB" wrote:


Hi Richz

Thanks for your answer. I know it's a bad thing which is why I want to
start declaring them.

Using the Option Explicit line was something I considered, but with the
number of variables I have this will take some time because when you do
a check the code always stops at the first undeclared variable,
irrespective of where the cursor is. I'd have to go back, declare it,
run the check again etc. I just wondered if there is a quicker way.

Strangely enough, I've declared all the variables in my functions, so
they're OK.

DJB


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