Create a Variable

[Shi]

Hi everyone!

I have a question...what should the difference in creating a variable in the edit sheet or in the script load? Why I should choose one way or the other? In which cases should be better one option than the other, or the limits of one option?

Thanks in advance!

[ArnadoSandoval · Accepted solution]

Hi @Shi 

Script variables are initialized each time you run the script, while sheet variables are not! they preserve the value between reloads!

hope this helps,