Alexander, Michael, 1972-
101 ready-to-use Excel macros.
Hoboken, N.J. : Wiley ; Chichester : John Wiley [distributor], ©2012
Michael Alexander; John Walkenbach
|ISBN:||9781118983928 1118983920 9781621984450 1621984451 9781118330685 1118330684 9781118333532 1118333535 9781118334669 1118334663|
|描述：||1 online resource (xvi, 319 pages :) : illustrations.|
|内容：||pt. 1. Getting started with Excel macros --
pt. 2. Working with workbooks --
pt. 3. Automating worksheet tasks with macros --
pt. 4. Selecting and modifying ranges --
pt. 5. Working with data --
pt. 6. Working with PivotTables --
pt. 7. Manipulating charts with macros --
pt. 8. E-mailing from Excel --
pt. 9. Integrating Excel and other office applications.
|叢書名：||Mr. Spreadsheet's bookshelf.|
|責任：||by Michael Alexander and John Walkenbach.|
Save time and be more productive with this helpful guide to Excel macros!While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book and online, and modify the macro for personal use. Shows you how to solve common problems with the featured macros, even if you lack extensive programming knowledge.