Link Search Menu Expand Document

SSpread.IsVisible Method

Explanation Returns whether the specified cell, row, or column is displayed within the display area of the spreadsheet.

Specify -1 for the argument col to specify only the row, and -1 for the argument row to specify only the column. However, only rows or columns are specified, the argument partial is invalid, and if only a part is displayed, $TRUE is returned.
Call format IsVisible(col, row, partial)
Return value $TRUE if the cell is visible, $FALSE if it is not visible
Arguments col Cell column position
row Cell row position
partial $TRUE to see only partially visible cells, $FALSE to see all visible cells
Example of use
    if (IsVisible(5, 10, $TRUE) == $TRUE) {
        MessageBox("(5, 10) is displayed");
    }
    
Exception None