Hi Ben,

The following line will select all errors on the active worksheet.
Application.Goto Cells.SpecialCells(xlCellTypeFormulas, 16)

The following line will select the first error on the active worksheet.
Application.Goto Cells.SpecialCells(xlCellTypeFormulas, 16).Cells(1)

Add the characters ",True" to the end of either of the above lines and the
spreadsheet will also scroll to selected cell.

Preceed the command with "On Error Resume Next" to avoid the VBA error when
no worksheet errors are found.


Regards,
Vic Eldridge



"bengamboni" wrote:


Hi There,

Just wondering if anybody knew the code to check through all cells in a
workbook for any error messages then goto that cell so that the user can
correct then proceed to the next error message?

Kind of like a find function for any errors such as #N/A #Value! etc.

Thanks,

Ben


--
bengamboni
------------------------------------------------------------------------
bengamboni's Profile: http://www.excelforum.com/member.php...o&userid=25378
View this thread: http://www.excelforum.com/showthread...hreadid=388578