cellRange

Function

This is one of the commands and functions used for working with Excel. (Added in SenseTalk 1.79)

The cellRange function accesses a rectangular range of cells in an excel worksheet.

Examples:

put worksheet1.cellRange ("C6", "E8") into columnsBasic // creates a list of lists for a range of cells

put cellRange("C:E") of worksheet1 into columnsBasic // using a colon, creates a list of lists for a range of columns

Further Reading

Resources in our other reference manuals.

• CellRange Function
• Excel File Interaction

Related Terms

Related terms in the SenseTalk Dictionary.

• writeCellRange