Accounting Answers

PROBLEM

macro error H221 or H222
when updating master addresses file in MacNail Construction Accounting Software

DIAGNOSIS

check the list of defined names for the Master Addresses file. If end.of.file is #REF, you've found the problem--they deleted 'end.of.file' row from Master Addresses file, and our code neglects to check for that and give a more appropriate error message

SOLUTION

1. select the row immediately under the last item in the Master Addresses file
2. Unprotect the document
3. Choose Define Name from the Formula menu
4. Under name, type in end.of.file with no spaces
5. Hit OK

COMMENTS

Entered 2/15/95 by Rudy.