blm@6sceng.uucp (Brian Matthews) (04/17/91)
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