Problem
macro error E55 or E56 in MacNail Customizing
DOS 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.
|
