Errata

Errata for Excel Hacks

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 "Date 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 Note Update

Version	Location	Description	Submitted By	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