Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dale Hymel Dale Hymel is offline
external usenet poster
 
Posts: 9
Default 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