I'm finding different answers on the internet. Are the number of cells I can alter at once directly related to the amount of RAM on the computer?
I was trying to use this code, but it gave me an out of memory error on the second line
Set Rng = Sht.Range(TL, TL.Offset(1000000, 700))
Rng.Value...