Microsoft Office Excel 2007 Visual Basic for Applications Step by Step

Reed Jacobson

PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399

Copyright © 2007 by Reed Jacobson

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

Library of Congress Control Number: 2007924651

Printed and bound in the United States of America.

1 2 3 4 5 6 7 8 9 QWT 2 1 0 9 8 7

Distributed in Canada by H.B. Fenn and Company Ltd.

A CIP catalogue record for this book is available from the British Library.

Microsoft Press books are available through booksellers and distributors worldwide. For further information about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax [phone]. Visit our Web site at www.microsoft.com/mspress. Send comments to [e-mail].

Microsoft, Microsoft Press, ActiveX, Calibri, Excel, Groove, InfoPath, Internet Explorer, MS-DOS, OneNote, Outlook, PivotTable, PowerPoint, SharePoint, SQL Server, Visio, Visual Basic, Visual Studio, Win32, Windows, Windows Server, and Windows Vista are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company names mentioned herein may be the trademarks of their respective owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred.

This book expresses the author’s view and options. The information in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

Acquisitions Editor: Juliana Aldous Atkinson

Developmental Editor: Sandra Haynes

Project Editor: Rosemary Caperton

Editorial and Production Services: Online Training Solutions, Inc.

Technical Reviewer: Jason Lee; Technical Review services provided by Content Master, a member of CM Group, Ltd

Body Part No. X13-68402

What do you think of this book? We want to hear from you!

Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you. To participate in a brief online survey, please visit:

www.microsoft.com/learning/booksurvey/

About the Author

Reed Jacobson is a Senior Architect with Hitachi Consulting, an international management and technology consulting firm. He worked as a Software Application Specialist for Hewlett-Packard for 10 years and ran his own consulting firm for 5 years.

Reed received a BA degree in Japanese and Linguistics. He also received an MBA degree from Brigham Young University and a graduate fellowship to study Linguistics at Cornell University.

In addition to authoring this book, Reed is the author of Excel Trade Secrets for Windows, Microsoft Excel Advanced Topics Step by Step, Microsoft Office 2000 Expert Companion, and Microsoft SQL Server Analysis Services Step by Step. He has given presentations at Microsoft and other conferences, and has taught courses around the world.

Your All-in-One Resource

On the CD that accompanies this book, you’ll find additional resources to extend your learning.

The reference library includes the following fully searchable titles:

• Microsoft Computer Dictionary, 5th ed.

• First Look 2007 Microsoft Office System by Katherine Murray

• Windows Vista Product Guide

Also provided are a sample chapter and poster from Look Both Ways: Help Protect Your Family on the Internet by Linda Criddle.

The CD interface has a new look. You can use the tabs for an assortment of tasks:

• Check for book updates (if you have Internet access)

• Install the book’s practice file

• Go online for product support or CD support

• Send us feedback

The following screen shot gives you a glimpse of the new interface.