Was this page helpful? If the named range is on another not the active worksheet, activate that worksheet first, and then select the range using the following example:. On such a range, you access single cells via Item row , column , where are relative to the upper-left corner of the first area of the range. The ColumnIndex can be provided either as a numeric index or as a column address string as in A1-notation, i. The ActiveWorkbook property can also usually be omitted.
nest...