EXCEL：儲存格的公式使用技巧

=IF(F2="","",INDIRECT("座號姓名!C"& (F2+4)))

=========================================

當儲存格的值寫入會引發其它儲存格的改變時，不可使用value，要改用FormulaR1C1 。如下面的例子。

=======================================
Sub 學生觀點寫入()


For n = 1 To 7
    j = n + 2
    k = 15 - (n - 1) * 2
    For i = 1 To 7
    Sheets("座位表初填").Cells(k, 12 - i).FormulaR1C1 = _
    Sheets("座位表初填_學生或老師觀點").Cells(j, i).FormulaR1C1
         
    Next i

Next n
Sheets("座位表初填").Select
End Sub
==============================================
Sub 老師觀點寫入()


For n = 1 To 7
    j = 24 - n + 1
    k = 15 - (n - 1) * 2
    For i = 1 To 7
    Sheets("座位表初填").Cells(k, 5 + (i - 1)).FormulaR1C1 = _
    Sheets("座位表初填_學生或老師觀點").Cells(j, i).FormulaR1C1
         
    Next i

Next n
Sheets("座位表初填").Select

End Sub
=================================================