I'm wondering if someone can let me know what the best method regarding global varilable usage vs Function Return values? Is there a reason to use one over the other? Is there a standard practice regarding both? Is one more effeicient then the other?
I'm not talking declaring all varialbles as global, only ones that are used outside of the scope of the subroutine.
I've done some searches and haven't found anything pretaining to this specfic topic, or with anyone who's judgement I would trust.
Thanks in advance.
Cal
PS- I'm looking at this from an Excel VBA perspective, although I'm sure it will apply to VB and programing in general as well.