Thread: Formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Alexander[_4_] Alexander[_4_] is offline
external usenet poster
 
Posts: 6
Default 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