NativeExcel suite v2.x

How to reference Cells and Ranges

A common task when using NativeExcel is to specify a cell or range of cells and then do something with it, such as enter a value or change the format.
A Range object in NativeExcel can be either a single cell or a range of cells. The following topics show the most common ways to identify and work with Range objects.
 
»Referring to Cells and Ranges using A1 notation
»Referring to Cells by using Index numbers
»Referring to Ranges by using Index numbers
»Referring to Rows
»Referring to Columns
»Referring to Ranges Relative to Other Ranges
Copyright © NikaSoft 2004-2012