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 an 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 place 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 main 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

COMMENTS

Entered 1/28/93 by Dennis.