Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / PreviousNonEmptyCell Method
The row index to find.
The start column index. If the cell in this column is not empty, it'll be returned too.


In This Topic
PreviousNonEmptyCell Method
In This Topic
Gets the nearest previous column which contains data in the specified row.
Syntax
'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)

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.
See Also

Reference

Worksheet Class
Worksheet Members

 

 

Copyright © 2021 GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page