Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |