# Errata for Excel Hacks

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

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

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