I have a script tab that I have added a large amount of long formulas to. It equals about 75 pages when copied into a word document,
I have noticed sever lag and process time when trying to edit anything on this tab.
Does anyone know of a way to increase the memory that the script needs when working on it? It is becoming a huge pain to work on, and still have a lot of troubleshooting and edits to do to it.
It currently takes about 4 seconds from clicking on a word for it to be highlighted.
Replacing certain script-parts through variables need not a lot of time - a few trials with the syntax (with or without quotas) and then searching and replacing per Ctrl + H. Replacing parts through loops is more difficult.
Perhaps an alternatively could be to separate the entire script in several loads (in several tabs) and concatenate these tables later.
