The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| Printed |
Page 10
Code Snippet |
In the March 2004 printing:
Lines 2-5 are incorrectly indented
Private Sub...
If Not...
With Ran....
.Copy Dest....
.Copy Dest....
End With
...
Should be
Private Sub...
If Not...
With Ran....
.Copy Dest....
.Copy Dest....
End With
...
|
Anonymous |
|
|
| Printed |
Page 34
3rd paragraph |
type an at sign (@).
NOW READS:
type an at sign (@), including the parentheses.
|
Anonymous |
|
Apr 01, 2006 |
| Printed |
Page 58
Formula on second line. |
=ADDRESS(1,$F$1)&":"&":"ADDRESS(7,$F$1)
Should be
=ADDRESS(1,$F$1) & ":" & ADDRESS(7,$F$1)
|
Anonymous |
|
|
| Printed |
Page 59
PIN Tip; Second to the last sentence in the tip; |
"...and cut and paste them into cell A2."
should be:
"...and cut and paste them into cell C2."
|
Anonymous |
|
|
| Printed |
Page 101
first equation |
The first MATCH statemet:
Is:
=MAX(MATCH"*",$A$3:$A$100,-1),MATCH(1E+306,$A$3:$A$100,1))
should be:
=MAX(MATCH("*",$A$2:$A$100,-1),MATCH(1E+306,$A$2:$A$100,1))
|
Anonymous |
|
|
| Printed |
Page 102
first equation |
The first MATCH statement is mistyped.
Is:
=OFFSET($A$1,0,0,MA>TCH(1E+306,$A:$A))
Should be:
=OFFSET($A$1,0,0,MATCH(1E+306,$A:$A))
|
Anonymous |
|
|
| Printed |
Page 105
Last line |
"In the Paste Name dialog, click OK..."
NOW READS:
"In the Paste Name dialog, click Paste List..."
|
Anonymous |
|
Apr 01, 2006 |
| Printed |
Page 126
3rd paragraph |
The formula:
=OFFSET($B$2,0,0,COUNTA($B:$B)-1,1)
should be:
=OFFSET($B$1,0,0,COUNTA($B:$B)-1,1)
|
Anonymous |
|
|
| Printed |
Page 131
3rd paragraph |
$A$6:$A$:11
NOW READS:
$A$6:$A$11
|
Anonymous |
|
Apr 01, 2006 |
| Printed |
Page 142
Figure 5-28 |
The value in cell E2 should be 180 instead of 200
and
the value of the highlighted cell (F3) should be 50, not 0
|
Anonymous |
|
|
| Printed |
Page 142
Last paragraph |
Chart Wizard step 2:
... and make sure your data is charted in rows.
should be:
... and make sure your data is charted in columns.
|
Anonymous |
|
|
| Printed |
Page 142
2nd to last paragraph |
"Press Alt/(Command symbol)-~ to show actual formulas..."
NOW READS:
"Press Ctrl ~ to show the actual formulas..."
|
Anonymous |
|
Apr 01, 2006 |
| Printed |
Page 143
1st new paragraph, in first sentence |
"Format Data Series".
NOW READS:
"select Format Data Point"
|
Anonymous |
|
Apr 01, 2006 |
| Printed |
Page 145
before the last paragraph |
add the following before the last paragraph on page 145 to make it a bit clearer:
Once you have exploded the pie and the slices are smaller, you then need to
click off the exploded pie. Now double click the smaller slices
individually and move them back together. They will remain small. If you
explode the pie, then drag it back together again without doing the slices
individually, it will take on its original size.
|
Anonymous |
|
|
| Printed |
Page 161
Next to last paragraph, first line |
"...enter the formula =#N/A()..."
NOW READS:
"...enter the formula =NA()..."
|
Anonymous |
|
Apr 01, 2006 |
| Printed |
Page 174-175
Hack 74; **PLEASE FIX IN NEXT REPRINT** |
The format for time is messed up for this hack. There are 2 colons instead of 1 between the
hours, minutes, seconds (i.e. 12::00::00 should be 12:00:00)
|
Anonymous |
|
|
| Printed |
Page 184
Fourth line from bottom |
"...John D."
NOW READS:
"...Jonn D."
|
Anonymous |
|
Apr 01, 2006 |
| Printed |
Page 195
in the last paragraph of Hack 84, after the first sentence the following needs to be added |
(Note - you need to name your button first, before creating the macros that the button should run)
|
Anonymous |
|
|
| Printed |
Page 231
|
The root element of the document, Worksheet
should be:
The root element of the document, Workbook
|
Anonymous |
|
|
