Hi Alexander!

Use:

=INDIRECT("MyWSheet!C"&A1)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Alexander" wrote in message
...
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