Errata

Excel 97 Annoyances

Errata for Excel 97 Annoyances

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page 180
Example 5-3 Top of Page

On Error Resume Next
lngRowIndex = lngRowIndex + 1
For Each cbarControl In CommandBars(strCBarName).Controls

This is wrong. The variable lngRowIndex must be incremented inside the For loop so
it should read:

On Error Resume Next
For Each cbarControl In CommandBars(strCBarName).Controls
lngRowIndex = lngRowIndex + 1

Anonymous