Excel Hacks 
by David Hawley, Raina Hawley

This errata page lists errors outstanding in the most recent printing.

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  Please specify the printing date of your copy.

This page was updated September 20, 2006.

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem
	?page-number?: reader question or request for clarification



Confirmed errors:



Hi errata folks,

Just noticed an error on the copyright page of Excel Hacks 2e that
should be fixed in the next reprint. On the third line, it should say
"Copyright © 2007, 2004 O'Reilly Media, Inc."--not just 2007.

Thanks,
Sanders




(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
...


(58)  Formula on second line.;
=ADDRESS(1,$F$1)&":"&":"ADDRESS(7,$F$1)

Should be

=ADDRESS(1,$F$1) & ":" & ADDRESS(7,$F$1)


(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."



{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))


(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))


[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)


(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


{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.



{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.



{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) 



{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)


(231)
The root element of the document, Worksheet
should be:
The root element of the document, Workbook