Get Cell

Read a cell value (by A1 or row/column) into a variable.

ExcelExcelGetCell

What it does

Read a cell value (by A1 or row/column) into a variable.

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
Store result invariable
Required
Example: value

More Excel commands

Ready to automate your busywork?

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