Set Cell

Write a cell value (by A1 or row/column).

ExcelExcelSetCell

What it does

Write a cell value (by A1 or row/column).

Parameters

ParameterTypeRequiredDefaultDescription
Excel instancevariable
RequiredexcelName that identifies this open workbook.
Sheet (blank = active)string
OptionalWorksheet name; blank uses the active sheet.
Supports variables
Reference bydropdown
A1 (Cell) · Row & Column
OptionalA1 (Cell)
Cell (A1) — for A1 modestring
Optional
Example: A1
Supports variables
Row (1-based) — for Row & Column modenumber
Optional
Example: 1
Supports variables
Column (1-based) — for Row & Column modenumber
Optional
Example: 1
Supports variables
Valuestring
OptionalValue to write. Variables are supported.
Supports variables

More Excel commands

Ready to automate your busywork?

Start your free 10-day trial today. No credit card, no commitment.