Tried it again and it worked just fine. Maybe I was trying to make it too
complicated by specifying what sheet it was to come from. =old in sheet2
picked up the value from sheet1 just fine without the specification of
$SHEET.. Thanks for the help.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <users@openoffice.org>
Sent: Friday, July 28, 2006 7:03 AM
Subject: [users] RE [users] Calc Formula
Mac,
In my little test I defined the name old on sheet1 en put the formula =old
on sheet2. No problems there, so it works just fine in my case.
Mac McClain schreef:
Arnold -- the =old only appears to work in the same sheet.
Arnold
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]