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
|