Chapter 14. Excel Power

IN THIS CHAPTER

File Operations

337

Combining and Separating Workbooks

341

Working with Cell Comments

345

Utilities to Wow Your Clients

351

Techniques for VBA Pros

357

Cool Applications

369

Next Steps

372

A major secret of successful programmers is to never waste time writing the same code twice. They all have little bits—or even big bits—of code that are used over and over again. Another big secret is to never take eight hours doing something that can be done in ten minutes—which is what this book is about!

This chapter contains programs donated by several Excel power programmers. These are programs they have found useful, and they hope these will help you, too. Not only can they save you time, but they may also teach you new ...

Get Business Solutions VBA and Macros for Microsoft® Office Excel® 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial