Match Value in Sheet Area

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

Parameters

  • Sheet location of left/top of the area eg MySheet[5,2] if the area starts at column 5, row 2
  • Number of columns in the area
  • Number of rows in the area
  • The numerical value to find
  • A data item (global or local) to receive the returned column number of the located cell
  • 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. 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 numerical cell in the left column first, then every numerical cell in the next column etc.

Related Commands

See Also