Hey Excel Experts,
I have an Excel file with a lot of VBA code behind it. I've been steadily
adding new functions and subs over the last few months and have noticed that
the debugger, in particular, is running very slowly. When I step through any
line of code (even the simplest ones such as IF i = 1, or CASE ELSE) it takes
over 1 second. I haven't done any benchmarking on the code execution itself
but it also seems to be running very slow.

Is there any way to easily determine whether there's a problem with the code
(memory leakage, variables not closing properly at the end of a procedure,
other things)? Any other ideas on how to tackle this problem? BTW this
project has about 900 public constants. I'm not sure if that's part of the
problem because I have another Excel file with almost no public constants but
has the same performance problems. Thanks in advance for any help you can
provide.

Best Regards,
Dean