View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marko marko is offline
external usenet poster
 
Posts: 10
Default Correct declaration of variables

Hi all,
Just a quick few Q's about good VBA programming practice.
When creating a vba function in a module that will be called repeatedly by a
macro, do the variable declarations go before the start of function or is it
better to declare them inside? Does it matter?
Are they created and destroyed everytime the function is run?
Is it good practice to set the variables to "" at the end of the function or
macro?

Marko