Office® XP Development with VBA

Excel Overview

You can think of an Excel file as an accountant's ledger containing many pages, with each page ruled into rows and columns. It's a truly enormous book, with each page containing 65,536 rows and 256 columns. Columns are identified by letters; the first 26 are A–Z, the second 26 are AA–AZ, and the last one is IV. Rows are identified by numbers starting at 1. The number of worksheets in a workbook is limited only by available memory.

At the intersection of each row and column, is a cell. A cell can contain a number, text, or a formula. Formulas provide much of Excel's power, permitting you to perform almost any kind of calculation on data in other cells in the same worksheet, or a different worksheet in the same or another workbook. ...