Excel Programming For Windows 95 For Dummies

John's Excel books

Errata

Ideally, I would like every book that I write to be completely accurate and error-free. The nature of the publishing industry makes this a difficult goal to achieve. However, I assume complete responsibility for the content of my books. Listed below are known errors in my Excel Programming for Windows 95 For Dummies. If you discover additional errors, please let me know.

NOTE: Most of the errors are incorrect line breaks inserted by members of the production department (who obviously don't understand VBA's line continuation rules).

NOTE: Some of these errors were corrected in subsequent printings of the book.

• Page 7:
  The coupon for the Power Utility Pak was omitted from the book. Click here to find out how to get your free copy.
• Page 37:
  In the second code example there should be a line continuation character ( _ ) at the end of the first line.
• Page 49:
  In the second-to-last paragraph, the second line should be: "the Copy method of the Range object." (the word Copy is messed up)
• Page 51:
  Figure 4-1 is incorrect. This figure should show the online help screen for a Rectangle object.
• Page 101:
  In the fourth code block, the statement should read:
  

MsgBox Sheets("Sheet1").Range("E3").Column 

• Page 103:
  In the second paragraph under The NumberFormat property, the second sentence should read: "To see a list of those formats, select a cell, open the Format Cells dialog box..."
• Page 115:
  The second statement in the code should be removed. Since the part numbers are text strings, converting the strings to a value will cause the macro to fail. When you enter the subroutine, omit this statement:
  

PartNum = Val(PartNum) 

• Page 115:
  The code block has an extra End Sub statement.
• Page 124:
  In the third and fourth code blocks, remove the line continuation characters. You cannot put a line continuation character inside of a text string.
• Page 129:
  In the second code block, the sixth and seventh statements should be combined as follows:
  

ActiveCell.Offset(CellCount, 0).Value = StartVal + CellCount. 

• Page 139:
  The code in the sidebar is messed up because of the narrow columns.
• Page 141:
  In the second code block, remove the underscore character ( _ ).
• Page 141:
  In the last line on the page, remove the underscore character ( _ ).
• Page 157:
  In the code block, remove the underscore character ( _ ) and put the word again on the same line. You cannot put a line continuation character inside of a text string.
• Page 177:
  In the first code block, the statement should not wrap to the next line.
• Page 184:
  In the last code block, the statement should read:
  

Set Rate = _ 
Workbooks("MyBook").Worksheets("Sheet1").Range("InterestRate") 

• Page 195:
  In the first code block, remove the line continuation character. You cannot put a line continuation character inside of a text string.
• Page 211:
  In the code block, remove the line continuation character. You cannot put a line continuation character inside of a text string.
• Page 280:
  The first code block should not have an underscore character. This is not VBA code, it's a worksheet formula.
• Page 326:
  In the third code block, the third line should is missing an underscore character ( _ ). It should read:
  

SourceData:="Sales!R1C1:R18C5", _ 

• Page 328:
  In the code block, the text wraps incorrectly and is not the code that would result from recording your actions (as described in the second paragraph).
• Page 331:
  In the code block, the text wraps incorrectly and is not the code that would result from recording your actions (as described in the preceding text).
• Page 334:
  In the code block, the text wraps incorrectly in the first part (importing the file). Also, the last statement (before End Sub) should not wrap.
• Page 343:
  The code block has two instances of double underscores. In both cases, there should be a single underscore ( _ ).
• Page 346:
  In the second code block, insert an ampersand ( & ) and a space before the underscore character.
• Page 347:
  In the second code block, the third line should not wrap around.