数式をcellに入れずに値だけを結果的にセルに入れる.
Sub pr1() Cells(1, 2).Formula = "=SUM(A1:A20)" Cells(1, 2).value = Cells(1, 2) 'Cells(1,2) = Cells(1,2)でもOK End Sub
Sub pr1() Cells(1, 2).Formula = "=SUM(A1:A20)" Cells(1, 2).value = Cells(1, 2) 'Cells(1,2) = Cells(1,2)でもOK End Sub