SearchDirection
(number) The direction of the search relative to the specified row and column. Choose from:
CONSTANT |
VALUE DESCRIPTION |
|
GVNI_ABOVE |
256 |
Search above initial cell. |
GVNI_BELOW |
512 |
Search all cells below initial cell. |
GVNI_TOLEFT |
1024 |
Search all cells to the left of the initial cell. |
GVNI_TORIGHT |
2048 |
Search all cells to the right of the initial cell. |
GVNI_ALL |
3584 |
Search all cells in the grid starting from the initial cell. |
GVNI_AREA |
2560 |
Search all cells below and to the right of the initial cell. |
Re t u r n s
(table) A table is indexed by "Row" and "Column" to specify the found cell's location. If an error occurs, nil will be returned. You can use Application.GetLastError to determine whether this action failed, and why.