NextNonEmptyColumnInRow Method (Worksheet)

In This Topic

Find the next non-empty data column in a row.

Syntax

Visual Basic
C#

'Declaration
 
Public Function NextNonEmptyColumnInRow( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   Optional ByVal skipInsideItems As Boolean _
) As Integer

'Usage
 
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim skipInsideItems As Boolean
Dim value As Integer
 
value = instance.NextNonEmptyColumnInRow(row, column, skipInsideItems)

public int NextNonEmptyColumnInRow( 
   int row,
   int column,
   bool skipInsideItems
)

Parameters

row: The anchor row index.
column: The anchor column Index
skipInsideItems: Return the last block index if the found cell is in block with the specified cell.

Return Value

The column index that contains data.

Reference

Worksheet Class
Worksheet Members

Product Support Forum | Print this page