Skip to main content

Change cell value

Changes the selected cell value.

This macro was converted from VBA code using the AI plugin.

(function(){
// Get the active sheet
var activeSheet = Api.GetActiveSheet();

// Select cell A1
activeSheet.GetRange("A1").Select();

// Set the value of the selected cell to "Hello World"
activeSheet.GetRange("A1").SetValue("Hello World");
})();

Methods used: GetActiveSheet, GetRange, Select, SetValue

Reference Microsoft VBA macro code

Sub ChangeCellValue()
Application.ActiveSheet.Range("A1").Select
Application.Selection.Value = "Hello World"
End Sub

Result

Change cell valueChange cell value