SpreadsheetGear 2023
FindUnlockedAndVisible Method (IRange)


SpreadsheetGear Namespace > IRange Interface : FindUnlockedAndVisible Method
Searches up or down if true otherwise searches left or right.
Searches left or up if true otherwise searches right or down.
Returns an IRange representing the next or previous unlocked and visible cell or null if no such cell is found.
Syntax
'Declaration
 
Function FindUnlockedAndVisible( _
   ByVal vertical As System.Boolean, _
   ByVal previous As System.Boolean _
) As IRange
'Usage
 
Dim instance As IRange
Dim vertical As System.Boolean
Dim previous As System.Boolean
Dim value As IRange
 
value = instance.FindUnlockedAndVisible(vertical, previous)
IRange FindUnlockedAndVisible( 
   System.bool vertical,
   System.bool previous
)

Parameters

vertical
Searches up or down if true otherwise searches left or right.
previous
Searches left or up if true otherwise searches right or down.

Return Value

An IRange representing the next or previous unlocked and visible cell or null if no such cell is found
Remarks

This method wraps past the ends of the worksheet if needed. To find the first

If the associated worksheet's ProtectContents property is false then the locked status of cells is ignored and the next or previous visible cell will be returned.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IRange Interface
IRange Members
Locked Property
Hidden Property
ProtectContents Property