Formula

A

Alexander

Hi all.

In cell B1 I have formula (right in the cell) as:

=MyWSheet!C128

The cell A1 value is 128.

How can I write next in cell B1 (but to work as formula, not to be
text-data):

=MyWSheet!C&"A1" or
=MyWSheet!C&"A1.value" or simillar?

Tnx in advance.

Alex
 
N

Norman Harker

Hi Alexander!

Use:

=INDIRECT("MyWSheet!C"&A1)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
A

Alexander

Ah guys... what a nice one. You new about that:) So fast... I didn't know
about indirect.

Thanks a lot to Dale Hymel and Norman Harker.
 
D

Dale Hymel

You can know alot about Excel, and still not know enought to keep you out of
trouble. Someone is always changing things.
 
A

Alexander

Exactly. And you know what? IF you don't work with all of that about year or
so...:)) you'll need some time to come back:) I've found indirect in
formulas:) Ellegant.
 
Top