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.
Prerequisite Data
These required data elements must be present in the automation before using the procedure.
Data Name
Data Type
the cell
Excel Cell
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
Examples
1. Set a Cell's Value to a New Value
get the worksheet's cell whose cell reference is "A1"
set the cell to "Updated value"
Last updated
Was this helpful?