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

NOTE-- In general, our newer Goldenseal accounting software program is much less fragile than MacNail. Bugs sometimes turn up but it's much less likely to give weird error messages, than MacNail.

Comments

Entered 2/15/95 by Randy. Updated 11/8/10.