Placement of Macros 

CRISTAL macro statements are stored in cells in the worksheet
environment.  Although macro statements can be located anywhere
in the sheet, proper positioning can be important to the
efficient structuring of program applications.  A location
unlikely to interfere with other worksheet procedures or data
sets such as the lower right hand corner of the sheet is
recommended, and this remote location will not have an adverse
effect on the amount of memory required by the worksheet file. 
Although each macro location might have a particular rationale
behind its placement, it may be best to avoid placement of macros
directly adjacent to a block of cells where worksheet data is
located because of the possibility of conflict between worksheet
manipulations and the macro commands.  For example, Macros can be
adversely affected or lost altogether by insertion or deletion of
rows or columns in the area of the worksheet that holds macro
statements, or by sorting a cell block which contains a macro
statement. 

<gfile01> Index to the Appendices
<gfile16> Macro Building
<gfile18> Application Development