Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!mips!cs.uoregon.edu!ns.uoregon.edu!milton!sumax!polari!6sceng!6sceng.uucp
From: blm@6sceng.uucp (Brian Matthews)
Newsgroups: comp.sys.mac.apps
Subject: Using cell contents as name of worksheet in Excel
Message-ID: <622@6sceng.UUCP>
Date: 16 Apr 91 19:52:17 GMT
Sender: blm@6sceng.UUCP
Distribution: na
Lines: 21

I'm using Excel 2.2, and trying to use the contents of a cell as the
name of another worksheet from which I use a value.  For example,
in worksheet2 at R1C1 I have "worksheet1".  In R2C1, I want to use
the value of the cell called "value" in whatever worksheet's name
appears in R1C1.

My first attempt was the obvious: put R1C1!value in R2C1 of worksheet2.
However, Excel complains about Error in formula and highlights R1C1.
I then tried some stuff using CELL and some other functions, and
finally gave up and wrote a little macro that uses TEXTREF to generate
a reference and return the value.  This works but means I need a
separate macro sheet, and the cell in worksheet2 isn't updated when
the referenced cell is changed.

So, the question is, is there any way to use the contents of a cell
as the name of another worksheet in a reference without using a
macro and so that things are update automatically?

Thanx,
-- 
Brian L. Matthews	blm@6sceng.UUCP