Ray Lee
Published: 2013-06
Total Pages: 367
Get eBook
Attention: Please purchase the ebook at the following link: https://www.copysafe.net/shop/prod.asp?prod=103671&Cat=73# Google Books is only an intermediary in terms of sales and especially of this ebook's proprietary format (.enc), it's much better to buy the ebook at the link rather than here. If you work with numeric data in Excel and constantly run into data problems that take too long to fix, you should think about using VBA to speed through your problems. This is a formal and practical training guide that takes you from syntax rules to contextual illustrations, the most frequently used objects and useful concepts are exposed to show you how they might be used in the real world. Time saving shortcuts, syntax subtleties and programming implications are thoroughly annotated. This ebook gives more than basic demonstrations of syntax usage, a strong focus is given to Excel object manipulations and these operations are covered in complete sets of operations, while it's meaningful to show how to delete a column but a corporate problem typically requires you to find multiple columns that match some criteria before deleting them, so it's more meaningful if a demonstration shows how you might go about solving the problem from start to finish rather than showing a few lines of code for only the deletion itself, this ebook gives such comprehensive content. The typical Excel user doesn't need to create overly complex solutions, for this reason this manual doesn't cover peripheral topics that either extend VBA's reach or substitute it in impractical ways. This ebook is not too trivial but not too heavy either, topic-wise and computationally. VBA is a simple programming language but the complexity of writing intelligent and reusable code is still a hurdle, ultimately you need to tell VBA what to do for it to do its magic, this is where the challenge is, this manual helps overcome that discounted complexity.