Get Range

Read a range into a list of rows (each row a list of cells).

ExcelExcelGetRange

What it does

Read a range into a list of rows (each row a list of cells).

Parameters

ParameterTypeRequiredDefaultDescription
Excel instancevariable
RequiredexcelName that identifies this open workbook.
Sheet (blank = active)string
OptionalWorksheet name; blank uses the active sheet.
Supports variables
Range (A1:C3)string
Required
Example: A1:C10
Supports variables
Store rows invariable
Required
Example: rows

More Excel commands

Ready to automate your busywork?

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