Add spaces: Ifyouworkwithbigtables/ranges,youcanusuallyspeedupthecodealot,ifyoucopytherangetoanarray.Onceyouhavefinishedoperatingonthearray,youcopythearraytothespreadsheetinonelightningfastoperation.
If you work with big tables/ranges, you can usually speed up the code a lot, if you copy the range to an array. Once you have finished operating on the array, you copy the array to the spreadsheet in one lightning fast operation.