Posted on 2014-03-10
Today's question is just a general information question but I have never had a definitive answer. So having said that...
Can somebody please explain to me why we should put our subs and functions in modules instead of the actual sheet itself? Is it because we want to be able to "Call" the subs/functions from the modules and this is easier than if the sub/functions are in the sheets themselves? Does it make the vba program run faster?
What are the benefits?