Match Text in Sheet Area

Parameters

• Sheet location - left/top of the area eg MySheet[5,2] if the area starts at column 5, row 2
• Columns - Number of columns in the area
• Rows - Number of rows in the area
• Text to find - Text string to be found in the sheet area. The text to be found should be put between double quotation marks (e.g. "Find me").

Alternatively a variable or spreadsheet reference can be used.

• Returned Column - A data item (global or local) to receive the returned column number of the located cell
• Returned Row - A data item (global or local) to receive the returned row number of the located cell

If the value is not found then column and row are returned as -1. If the value exists in more than one cell in the area only the first location is returned. Simul8 searches each column from the left of the area checking every cell in the left column first, then every cell in the next column etc.

Example

''Match Text in Sheet Area MySheet[1,1],10,10,"Simul8",gblColumn, gblRow''

This example searches for the text string "Simul8" in the spreadsheet area A1:J10 and returns the cell location using gblColumn (global number) and gblRow (global number).

match_text_in_sheet_area.s8

Match Value in Sheet Area