Sub test()
Sheets("Sheet1").Cells(3,2).Formula = "test"
End Sub
や
function test() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName( "Sheet1" );
sheet.getRange( 3, 2 ).setValue( "test" );
}
みたいにベタでコードを書き込むより使いやすいでしょう?
Sub test()
Call set_sheet_cell( "Sheet1", 3, 2, "test" )
End Sub
Sub set_sheet_cell( ByVal sheet_name As String, ByVal y As Integer, ByVal x As Integer, ByVal a As Variant )
Sheets(sheet_name).Cells(y, x).Formula = a
End Sub