Formula
 

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

Formula
 

Try:
=Indirect ("myWSheet!C" & A1)


"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

Formula
 

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

Formula
 

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.


Use:

=INDIRECT("MyWSheet!C"&A1)

--------------------------------
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

Formula
 

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


"Alexander" wrote in message
...
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.


Use:

=INDIRECT("MyWSheet!C"&A1)

--------------------------------
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

Formula
 

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.


"Dale Hymel" wrote in message
news:kj5Ib.13430$WQ3.7964@lakeread05...
You can know alot about Excel, and still not know enought to keep you out
of
trouble. Someone is always changing things.


"Alexander" wrote in message
...
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.


Use:

=INDIRECT("MyWSheet!C"&A1)

--------------------------------
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