Home / MS-Excel / General Formatting

Excel Programming

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 tutorial looks closely at that interaction. You learn how to work with all the most common Excel objects, including the Workbook, Worksheet, and Range objects.