Parse Method (CellRange)

In This Topic

Converts a string to a cell range.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function Parse( _
   ByVal s As String _
) As CellRange

'Usage
 
Dim s As String
Dim value As CellRange
 
value = CellRange.Parse(s)

public static CellRange Parse( 
   string s
)

Parameters

s: String to be parsed

Exceptions

Exception	Description
System.ArgumentNullException	s is a null reference (Nothing in Visual Basic).
System.FormatException	s does not represent a cell range.

Remarks

The text passed to the Parse method must contain the cell name(s) as a column name (as one or more letters) following by the row number (as one or more digits). The row number is 1-based.

Example

This example sets the backcolor of the cell.

Visual Basic

Reference

CellRange Class
CellRange Members

Product Support Forum | Print this page