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 |