Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everybody,
I just wonder which way is more effective: If I have a function which I use many times in a procedure is it better to call the functiom each time I need it or to declare a brand-new local variable and set it equal to the function result in the beginning of my code? The result of the function is not changed during this particular procedure. Thanks for answer. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using the variable would be more efficient.
-- Regards, Tom Ogilvy "Roman" wrote in message ups.com... Hi everybody, I just wonder which way is more effective: If I have a function which I use many times in a procedure is it better to call the functiom each time I need it or to declare a brand-new local variable and set it equal to the function result in the beginning of my code? The result of the function is not changed during this particular procedure. Thanks for answer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What would be the most effective way to do this? | Excel Worksheet Functions | |||
More effective than DAYS360? | Excel Worksheet Functions | |||
effective gross income | Excel Worksheet Functions | |||
ScreenUpdating not effective | Excel Programming | |||
A More Effective Way of Using PasteSpecial? | Excel Programming |