8. Programming Excel

In This Chapter

Working with Excel's Application object

Accessing worksheet functions in your code

Running a procedure at a certain time or when the user presses a certain key

• Manipulating Workbook objects in your VBA code

• Dealing with Worksheet objects

• Specifying and working with Range objects

If you're using VBA in Excel, most of your procedures will eventually do something to the Excel environment. They might open a workbook, rename a worksheet, select a cell or range, enter a formula, or even set some of Excel's options. Therefore, knowing how VBA interacts with Excel is crucial if you ever hope to write useful routines. This chapter looks closely at that interaction. You learn how to work with all the most ...

Get Absolute Beginner's Guide to VBA 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.