Setting a Constant

[cstimart]

I have a couple functions that are used several times within a macro. Is it possible to set the value of that function as a constant to speed up the macro?

 

[Jaafar Tribak]

If the return of the function remains the same in all calls to the function then, I guess, you could store the function return once upon its first call in a variable then use the variable value in lieu of the subsequent calls.

Not sure I phrased the idea clearly

 

[Ruddles]

You can't assign the value of a function to something which is declared as constant, but you can declare a variable and assign the value to the variable, then use the variable throiughout your code.

You're probably going to have to show us the code.