Excel 2003 Power Programming With VBA


Return to The Spreadsheet Page

Excel 2003 Power Programming With VBA

Errata

Ideally, I would like every book that I write to be completely accurate and error-free. The fast-paced nature of the computer book publishing industry makes this goal difficult to achieve. However, I assume complete responsibility for the content of my books.

Listed below are known errors in my Excel 2003 Power Programming With VBA book. If you discover additional errors, please let me know.


  • Page 47
    In the last formula at the bottom of the page, the filename is missing the ".xls" extension.
  • Page 48
    In the sidebar, the formula is missing a a single quote mark. It should be:

    ='C:\Files\[Badfile.xls]Sheet1'!$A$1
  • Page 266
    In the Test Sub procedure, the last statement should be Next Sht (not Next Item).
  • Page 290
    In the Commission function procedure, the second Case statement should read "10000 To 19999.99.
  • Page 292
    In the Commission2 function procedure, the second Case statement should read "10000 To 19999.99.
  • Page 523
    In the first line, USERFORM is misspelled USERFROM.

  •  

### End of known errors ###