2007-04-05 05:58:02 UTC
properly 'set up'. If the page contains a shapesheet cell
(thePage!User.Scale" in this case), then the value should be used; otherwise
a default value should be used.
I can see the FormulaExists function, and it seems to work OK within an IF()
function of the form IF(FormulaExists("thePage!User.Scale")=0,
"Value1","Value2"), but I get the "error in formula" message from from
IF(FormulaExists)"thePage!User.Scale")=0,90 mm, thePage!User.Scale)
The error highlights the 'false' part of the IF function parameter.
In other words, what I'm trying to do is use the page value if it exists,
and otherwise use the default of 90 mm.
cna this be done? If so how.