MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cells & Rows


Posted by How to on January 15, 2002 6:58 AM

Hi all,
simple question:
is possible to assign a cell value as a cell row or column reference?

Like: =A9 --> =A(3*3)

Sorry, i'm a newbye......
Thanks


Posted by Mark W. on January 15, 2002 7:03 AM

=INDIRECT("A"&3*3)

Posted by My Way on January 15, 2002 7:12 AM

HI
I just tried it and this is what I came to:

cell value/formula
A9 9
D1 3
E1 3
F1 =e1+d1
g1 =TEXT(f1,0)
h1 =CONCATENATE("A",G1)
i1 =INDIRECT(H1)

Put this values in your worksheet and see if this is what your' looking for.

Posted by My Way on January 15, 2002 7:16 AM

Mark W, you're the one