I tested filling a formula into adjacent cells by using the Fill command. The problem is that, the worksheet I'm testing contains only 11 rows and the aforementioned method filled my formula down to the 1,048,576th row.
I don't mind if it fills my formula down to the 1,000th row, but filling 1,048,576 rows is too much and that caused a freeze of 2~3 seconds.
I don't mind if it fills my formula down to the 1,000th row, but filling 1,048,576 rows is too much and that caused a freeze of 2~3 seconds.