Set a Cell's Value

Sets the value of a cell in a worksheet to a specified text or formula.

Overview

This procedure sets the value of a cell in a worksheet to a specified text or formula. It's useful for dynamically updating spreadsheets with new data or calculations.

Only text values can be used to set the value of a cell for this procedure.

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

set the cell to "cell-value"

What does it do?

Sets the cell's value to the specified string.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace cell-value with the new text value. If the value starts with '=', it will be treated as a formula.

Example

set the cell to "Updated value"

Examples

1. Set Cell to Text Value

Updates a cell with a new text value.

get the worksheet's cell where
    the cell reference is "A1"
set the cell to "Updated value"

2. Set Cell to Formula

Sets a cell to contain a formula.

get the worksheet's cell where
    the cell reference is "C1"
set the cell to "=A1+B1"