Macro Error F129 or D178

Problem

Macro error F129 or D178 when choosing Ledger Item in MacNail accounting software.

Diagnosis

This occurs with Excel 4.0 and newer. Cell F129 in the Manager somehow gets its formula changed-- an exclamation mark gets turned into a close parenthesis.
In MacNail Accounting Manager 3.3a or 3.3b, the formula SHOULD be =FORMULA.FILL("=IF(RC[-7]="""&""",""--"",HLOOKUP(RC[-7],'master index'!suppliers,RC[-6]+2)) ")

In 3.4 we moved that function, so a code change in the same piece of code will occur at D178

Solution

This was reported to Microsoft on 1/28/93, but it doesn't look like they'll do anything about it. These code change problems were one of the major reasons why we abandoned MacNail construction accounting software and replaced it with Goldenseal.

If macro errors start appearing at D178 in Accounting 3.4, then that cell has problems somehow and we'll rewrite it.
If macro errors appear in the F column (update payroll files, mostly) then we have better evidence for a real Excel bug. F129 is now a very short line of code so hopefully it won't change.
flag for Microsoft

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 1/28/93 by Dennis. Updated 11/8/10.