Is there a way I can verify that I have used the minimum number of
variables that will do the task?

Not really, if you're looking for something automatic or automated. If you
think you've declared variables that you do not use you can do a Find on
them, limiting the Find scope to the current procedure. If it's just one or
two, as you said, it is not worth the bother however,

A better question might be, if your procedure is so big that it's hard to
know what variables are used in it, whether you shouldn't have chunked out
your code into smaller, easier to understand and maintain, sub procedures.


--
Jim Rech
Excel MVP