Excel Vba Macro
Excel 2007 VBA Macro Programming
®
About the Author
Richard Shepherd has worked for many years for major banks and corporations in the United Kingdom writing spreadsheet macros to solve specific problems. He has worked for National Grid plc (electricity distribution), Hertz Car Leasing, NatWest plc (retail banking), Schroders plc (fund management), BNP Paribas (investment banking), Lloyds TSB plc (corporate banking), The Royal Bank of Scotland plc (investment banking), and the British National Health Service. He has developed advanced spreadsheets and macros for budgeting, business planning, and profit and loss reporting. He originally started working with Lotus 123 spreadsheets but moved some years ago to Microsoft Excel and Microsoft Access. He qualified as an accountant with the Chartered Association of Certified Accountants in 1976 and has been a Fellow since 1981. He can be contacted at tollside@yahoo.com, but he cannot promise to answer every e-mail!
About the Technical Editor
Todd Meister has been developing using Microsoft technologies for over ten years. He’s been a technical editor on over 50 titles ranging from SQL Server to the .NET Framework. Besides technically editing titles, he is an assistant director for Computing Services at Ball State University in Muncie, Indiana. He lives in central Indiana with his wife, Kimberly, and their four remarkable children.
Excel 2007 VBA Macro Programming
®
Richard Shepherd
New York Chicago San Francisco Lisbon London Madrid Mexico City Milan New Delhi San Juan Seoul Singapore Sydney Toronto
Copyright © 2010 by The McGraw-Hill Companies. All rights reserved. Except as permitted under the United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of the publisher. ISBN: 978-0-07-162701-6 MHID: 0-07-162701-4 The material in this eBook also
®
About the Author
Richard Shepherd has worked for many years for major banks and corporations in the United Kingdom writing spreadsheet macros to solve specific problems. He has worked for National Grid plc (electricity distribution), Hertz Car Leasing, NatWest plc (retail banking), Schroders plc (fund management), BNP Paribas (investment banking), Lloyds TSB plc (corporate banking), The Royal Bank of Scotland plc (investment banking), and the British National Health Service. He has developed advanced spreadsheets and macros for budgeting, business planning, and profit and loss reporting. He originally started working with Lotus 123 spreadsheets but moved some years ago to Microsoft Excel and Microsoft Access. He qualified as an accountant with the Chartered Association of Certified Accountants in 1976 and has been a Fellow since 1981. He can be contacted at tollside@yahoo.com, but he cannot promise to answer every e-mail!
About the Technical Editor
Todd Meister has been developing using Microsoft technologies for over ten years. He’s been a technical editor on over 50 titles ranging from SQL Server to the .NET Framework. Besides technically editing titles, he is an assistant director for Computing Services at Ball State University in Muncie, Indiana. He lives in central Indiana with his wife, Kimberly, and their four remarkable children.
Excel 2007 VBA Macro Programming
®
Richard Shepherd
New York Chicago San Francisco Lisbon London Madrid Mexico City Milan New Delhi San Juan Seoul Singapore Sydney Toronto
Copyright © 2010 by The McGraw-Hill Companies. All rights reserved. Except as permitted under the United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of the publisher. ISBN: 978-0-07-162701-6 MHID: 0-07-162701-4 The material in this eBook also