要回答原始问题:

使用数据数组，在大范围的单元格上它的速度明显更快

use a data array, which will be significally faster on large ranges of cells

Source = ThisWeek.getCellRangeByName("H12:H206")
source_data = Source.getDataArray()

Target = Steering.getCellRangeByName("M12:AU206").setDataArray(source_data())