PrintNumber ErrorLocation Error Correction DateAdded
2 p47 2nd line: wwindow window 4/22/2008
1 p115 Top of page code, 6th line:
Cell.Offset(0, 4)
Cell.Offset(0, 2) 9/26/2008
3 p ii update print-line done 9/30/2008
5 p ii Third Printing: October 2008
Sixth Printing: May 2010 4/23/2010
5 p 50 From the VB Editor Debut menu, select Add Watch. From the VB Editor Debug menu, select Add Watch. 4/23/2010
6 pii Sixth Printing: May 2010 Seventh Printing: December 2010 11/30/2010
6 p93 SortConcat = Left(MySum, Len(MySum) - 2) SortConcat = Left(MySum, Len(MySum) - 1) 11/30/2010
6 pii Seventh Printing: December 2010 Eighth Printing: May 2012 4/11/2012
6 p123 (Ctrl+~ in Excel switches between Normal view and Formula view.) (Ctrl+` in Excel switches between Normal view and Formula view.) 4/11/2012
6 p124 Figure 6.5
Press Ctrl+~ to switch to showing formulas rather than their results. It is amazing that Excel adjusts the cell references in each formula as you copy down the column.
Figure 6.5
Press Ctrl+` to switch to showing formulas rather than their results. It is amazing that Excel adjusts the cell references in each formula as you copy down the column.
4/12/2012
6 p125 Case Study, 13th line of code:
Cells(FinalRow + 1, 6).Formula = “=SUM(G4:G” & FinalRow & “)”
Cells(FinalRow + 1, 7).Formula = “=SUM(G4:G” & FinalRow & “)” 4/12/2012
6 p125 Case Study, 2nd to last line of code:
Cells(FinalRow + 1, 6).Formula = “=SUM(G4:G” & FinalRow & “)”
Cells(FinalRow + 1, 7).Formula = “=SUM(G4:G” & FinalRow & “)” 4/12/2012
6 p153 Case Study, 2nd to last line of code:
ActiveWorkbook.Range(“A1”).CurrentRegion.Copy Destination:=WSD.Range(“A1”)
ActiveWorkbook.Sheets(1).Range(“A1”).CurrentRegion.Copy Destination:=WSD.Range(“A1”) 4/12/2012