Bob, thanks for the tip, and J.E., thanks for the warning.
I can make this work if I enter the absolute cell reference ("$a$1"), but
if i just enter it as ("a1"), then when I enter =formulatext in the cell
where I want the formula to display, it displays "=formulatext" rather than
the formula itself.
What I entered as the reference for insert-name-define formulatext was
"Get.cell(6,d9)" (without the quotation marks). Entering Get.cell(6,$d$9)
works, but as you said, displays info for the single absolute cell only.
Thanks,
Tom
|
