PreviousNonEmptyCell Method

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public Function PreviousNonEmptyCell( _
   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.PreviousNonEmptyCell(row, excludeColumn)

public int PreviousNonEmptyCell( 
   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 previous column which contains data in the specified row.

Reference

Worksheet Class
Worksheet Members

Product Support Forum | Print this page