Speed-readability trade-off

[chengafni]

Hi,

I have a very long code that was written as one chunk and is not very comfortable to read. I would like to break the code into smaller subs and functions for readability.
My problem is that in most cases, a piece of code with a defined purpose changes more than one variable (often of different types), which forces me to use functions that output variants, and this reduces the speed significantly.
Is there any way to organize the code better without compromising speed?

Thanks,
Chen

[MrShorty]

If I understand what you are asking, I think one solution would be to use module level variables (assuming all of the procedures are in the same module). This article has a nice discussion of "variable scope" http://www.cpearson.com/Excel/Scope.aspx

[chengafni]

You understood correctly. I tested your suggestion on a sample code and it looks promising!
(I tried solving the problem using public declaration, but your way works much better)
Many thanks!