Creates a new cells enumerator for the specified sheet area with the specified search order for the specified search range.
Syntax
'Declaration
Public Function New( _
ByVal As Worksheet, _
ByVal As SheetArea, _
ByVal As SearchOrder, _
ByVal As Integer, _
ByVal columnStart As Integer, _
ByVal As Integer, _
ByVal columnEnd As Integer _
)
'Usage
Dim worksheet As Worksheet
Dim sheetArea As SheetArea
Dim searchOrder As SearchOrder
Dim rowStart As Integer
Dim columnStart As Integer
Dim rowEnd As Integer
Dim columnEnd As Integer
Dim instance As New CellsEnumerator(worksheet, sheetArea, searchOrder, rowStart, columnStart, rowEnd, columnEnd)
Parameters
- worksheet
- The sheet.
- sheetArea
- The sheet area.
- searchOrder
- The search order for this enumerator.
- rowStart
- The starting row to enumerate.
- columnStart
- The starting column to enumerate.
- rowEnd
- The ending row to enumerate.
- columnEnd
- The ending column to enumerate.
See Also