Method: Find for Sheet

Download PDF

Updated2024-09-12
1 minute(s) read

Determines the position of a character or a character string in a worksheet of the open work folder. The search is executed rowwise.

Set oCellPosition = Object.Find(SearchText, [Row], [Column])

Object	Sheet Object with this method
SearchText	String Specifies the text to search for.
[Row]	LongInteger Specifies the row number from where the search starts.
[Column]	LongInteger Specifies the column number from where the search starts.
oCellPosition	CellPosition Returned object

The following example searches for the letter a in the first worksheet. The example saves the positions it finds in the properties of the channel group Find_Results:

Copy script

Dim oSheet : Set oSheet = Workbook.Sheets(1)
Dim oGroup : Set oGroup = Root.ChannelGroups.Add("Find_Result")

Dim Count : Count = 0
Dim RetVal : Set RetVal = oSheet.Find("a")

While (RetVal.Row>0) and (RetVal.Column>0)
  Count = Count +1
  Call Group.Properties.Add("Pos" & Cstr(Count), Cstr(RetVal.Row) & "," & cstr(RetVal.Column)) 
  Set RetVal = oSheet.Find("a", RetVal.Row, RetVal.Column+1)
Wend

Examples

Checking DataPlugins for Timeout

DIAdem Help

Table of Contents

Method: Find for Sheet

See Also

Examples