Searching multiple worksheets for different numbers simultaneously in Excel

KennyK360 

That could be like

function main(workbook: ExcelScript.Workbook) {

    const range = workbook
        .getActiveWorksheet()
        .getUsedRange()

    const nRows = range
        .getRowCount()
    
    let j = 0;
    let nErrors: number[] = [];

    for( let i = 0; i < nRows; i++) {
        if ( range
                .getRow(i)
                .getValueTypes()
                .toString()
                .includes("Error")
        )  nErrors.push(i) 
    }

    nErrors.map( x => {
        range
            .getRow(x - j)
            .getEntireRow()
            .delete(ExcelScript.DeleteShiftDirection.up);
         j++
    } )
}