minimum # of variables

  • Thread starter Thread starter Jamie Martin
  • Start date Start date
J

Jamie Martin

This is probably a complicated question . . .

I have just finished a fairly large (for me) sub procedure. I think I may
have ended up using one or two more variables than I needed. Is there a way
I can verify that I have used the minimum number of variables that will do
the task?

Thanks again, everybody, for your excellent advice . . .

Jamie
 
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.
 
hi,
visit http://www.mztools.com/ and download mz-tools.
that add-in has several utilities for vba codes like "Review Source Code".
when you run that utility, it shows unused variables in project.


Regards

Haldun
 
Back
Top