Identifying Errors

Errors in Cells

Some errors are highlighted within the cells in the worksheet grid. If a cross appears in a cell, it highlights an error. There are different colours for different types of error.

Pink Cross in a cell : Cycle Error

The references to cells or ranges are cyclical so that there is no absolute defined value, for example A10 = B4, B4 = A10.

Orange Cross in a cell : Duplicate Header Error

There are two or more rows with the same Header name, or columns with the same Header name.

Green Cross in a cell : Zero Division Error

There has been an attempt to divide by zero.

Red Cross in a cell : One of:

Formula Error - There is a problem with the structure/syntax of a formula.

Type Error - There is an object of the wrong type e.g. text when a numerical value would be expected.

All Other Types of Errors

Errors in User Code

Errors in the user code are highlighted with a warning triangle in the left margin. The warning triangle is positioned next the the point in the code where the error occurs. Floating the cursor over the warning triangle causes a pale yellow call out to appear that gives an indication of the type of error. The error is also highlighted in red at the side of the scroll bar to the right of the coding pane. When you click away from the coding pane into the grid or output pane, the first line of code where an error occurs is highlighted in red.

Errors in Worksheet Formulae

If there is an error in a worksheet formula, there will be a coloured corner in the top left-hand side of the worksheet as shown below. The coloured error warning square is colour-coded to indicate error type, just as with cell errors.