Macro Error E55

Problem

macro error E55 or E56 in MacNail Customizing
Windows version only-- only in one dated 2/2/97

Diagnosis

gives macro error when updating material prices for MacNail construction estimating software. This is an old bug that only surfaced when we started actually using markup

Solution

In custom.XLM, go to cell E51. It should be:
=IF(ISERROR(VALUE(E50)),IF(prob.prompt,ALERT("Sorry, bad or missing material price for "&E47,2)),GOTO(E53))
If they have E48, change it.
also, go to cell E49. Change the reference from E48 to E47.

note: if older Manager, they may have to go to E50. Cell should be
=IF(ISERROR(VALUE(E49)),IF(prob.prompt,ALERT("Sorry, bad or missing material price for "&E46,2)),GOTO(E52))
If they have E47, change it.

Comments

Entered 4/4/97 by Casey. Updated 11/14/2010.