Quickly search an area of a SIMUL8 spreadsheet and return the location (in column/row coordinates) that exactly matches a text string.

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.