Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Declaration. | Excel Discussion (Misc queries) | |||
Workbook Declaration | Excel Discussion (Misc queries) | |||
VBA - variable declaration | Excel Discussion (Misc queries) | |||
type declaration characters | Excel Discussion (Misc queries) | |||
Variable Declaration?? | Excel Programming |