Errata

Print Print Icon

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. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question



Version Location Description Submitted By 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 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 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 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 2006
Printed Page 143
1st new paragraph, in first sentence

"Format Data Series".

NOW READS:
"select Format Data Point"

Anonymous  Apr 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 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 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