NextNonEmptyCell Method (Worksheet)

In This Topic

Gets the nearest next column which contains data in the specified row.

Syntax

Visual Basic
C#

'Declaration
 
Public Function NextNonEmptyCell( _
   ByVal row As Integer, _
   ByVal excludeColumn As Integer _
) As Integer

'Usage
 
Dim instance As Worksheet
Dim row As Integer
Dim excludeColumn As Integer
Dim value As Integer
 
value = instance.NextNonEmptyCell(row, excludeColumn)

public int NextNonEmptyCell( 
   int row,
   int excludeColumn
)

Parameters

row: The row index to find.
excludeColumn: The start column index. If the cell in this column is not empty, it'll be returned too.

Return Value

The nearest next column which contains data in the specified row.

Reference

Worksheet Class
Worksheet Members