What kind of cell am I? (efficient macro techniques) (tutorial)

What Kind of Cell Am I?

Developers commonly use macros to sift through and change data in large ranges. The larger the range, the more important efficient macro coding becomes. Consider the task of erasing all unprotected cells in a range 5 colums wide and 1,000 rows deep. A macro would have to chek 5,000 cells for the protect attribute and erase each one that wasn't protected. Ideally, the macro would do so quickly.

You can use one of the macro techniques presented here to quickly determine the attributes of each cell in a range and then alter or erase the appropriate cells. One of the methods moves the cell pointer and examines each cell. A faster but more complex method uses string formulas and never moves the cell pointer.

A SIMPLE TECHNIQUE

Figure 1 shows a small portion of a balance …