Hi. Today’s video will show you how to delete rows of data based on cell errors across worksheets. As we can see, some of the trade data contains error values in column J throughout the sheets

We will write a macro that will identify these rows with cell errors and delete them. Go to Visual Basic for Applications, and insert a Module.

Download Spreadsheet Vault SpreadsheetVault – Delete error rows multi sheets (solution)