Errata

Microsoft® Office Excel® 2007 Visual Basic® for Applications Step by Step

Errata for Microsoft® Office Excel® 2007 Visual Basic® for Applications Step by Step

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

**NOTE**

If for any reason you are unable to install the practice files from the CD, the files can also be downloaded from the web at http://examples.oreilly.com/9780735624023-files/.

Microsoft Press  Nov 11, 2005 
Printed
Page 18

Incorrect shortcut key in Step 5
On page 18, step 5 includes an incorrect shortcut key combination.

Change:
"5. Press Ctrl+Shift+M."

To:
"5. Press Ctrl+Shift+S."

Microsoft Press  May 06, 2010  May 04, 2012
Printed
Page 123

Sub() should be Sub
On page 123, the last line of the code sample in step 2 contains extra parentheses.



Change:

End Sub()To:

End Sub

Microsoft Press  Jul 13, 2010  May 04, 2012
Printed
Page 125

myOuter should be myInner
On page 125, the second sentence of step 5 is contains an incorrect instruction.

Change:
"When you can confi rm the correct range by entering myOuter.Select, copy the statement into the macro."

To:
"When you can confi rm the correct range by entering myInner.Select, copy the statement into the macro."
Microsoft Press is committed to providing informative and accurate
books. All comments and corrections listed above are ready for
inclusion in future printings of this book. If you have a later printing
of this book, it may already contain most or all of the above corrections.

Microsoft Press  May 06, 2010  May 04, 2012