| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple question
How can I designate in a formula a cell regarding to a variable (e.g.
M(value of n) is the cell M535 if n=535 ) thank you , John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
simple question
Hi John,
If I understand correctly, following should help =CELL("contents",M535) HTH Cheers Carim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
simple question
Thank you Carim,
I think my problem needs macros... Bye If I understand correctly, following should help =CELL("contents",M535) HTH Cheers Carim |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
simple question
=indirect("M"&a1)
if A1 contained N) In code: dim N as long msgbox activesheet.range("M"&n).value 'or msgbox activesheet.cells(n,"M").value john wrote: How can I designate in a formula a cell regarding to a variable (e.g. M(value of n) is the cell M535 if n=535 ) thank you , John -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
simple question
Hi Dave,
thank you... i am progressing; I am still in trouble because my needs with this is to input a result in a cell designated by a variable; something like that-syntax is uncorrect, but i can't do better- : formula in cell B3 =SI(B20; "cell" M(value of n)= B2 ; "cell" M(value of n)= 0) in words, is it possible with a formula in one cell to put a result in another cell, with the adresse of the last one depending on a variable...? =indirect("M"&a1) if A1 contained N) In code: dim N as long msgbox activesheet.range("M"&n).value 'or msgbox activesheet.cells(n,"M").value john wrote: How can I designate in a formula a cell regarding to a variable (e.g. M(value of n) is the cell M535 if n=535 ) thank you , John -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
simple question
It looks like you're trying to change a cell by using a formula in B3.
Excel won't let formulas in one cell change another cell's value. john wrote: Hi Dave, thank you... i am progressing; I am still in trouble because my needs with this is to input a result in a cell designated by a variable; something like that-syntax is uncorrect, but i can't do better- : formula in cell B3 =SI(B20; "cell" M(value of n)= B2 ; "cell" M(value of n)= 0) in words, is it possible with a formula in one cell to put a result in another cell, with the adresse of the last one depending on a variable...? =indirect("M"&a1) if A1 contained N) In code: dim N as long msgbox activesheet.range("M"&n).value 'or msgbox activesheet.cells(n,"M").value john wrote: How can I designate in a formula a cell regarding to a variable (e.g. M(value of n) is the cell M535 if n=535 ) thank you , John -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
simple question
well, it is exactly the aim, so no solutions....?
It looks like you're trying to change a cell by using a formula in B3. Excel won't let formulas in one cell change another cell's value. john wrote: Hi Dave, thank you... i am progressing; I am still in trouble because my needs with this is to input a result in a cell designated by a variable; something like that-syntax is uncorrect, but i can't do better- : formula in cell B3 =SI(B20; "cell" M(value of n)= B2 ; "cell" M(value of n)= 0) in words, is it possible with a formula in one cell to put a result in another cell, with the adresse of the last one depending on a variable...? =indirect("M"&a1) if A1 contained N) In code: dim N as long msgbox activesheet.range("M"&n).value 'or msgbox activesheet.cells(n,"M").value john wrote: How can I designate in a formula a cell regarding to a variable (e.g. M(value of n) is the cell M535 if n=535 ) thank you , John -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
simple question
Not using formulas.
Macros can change values in cells--but I don't think I know enough to offer a real solution. john wrote: well, it is exactly the aim, so no solutions....? It looks like you're trying to change a cell by using a formula in B3. Excel won't let formulas in one cell change another cell's value. john wrote: Hi Dave, thank you... i am progressing; I am still in trouble because my needs with this is to input a result in a cell designated by a variable; something like that-syntax is uncorrect, but i can't do better- : formula in cell B3 =SI(B20; "cell" M(value of n)= B2 ; "cell" M(value of n)= 0) in words, is it possible with a formula in one cell to put a result in another cell, with the adresse of the last one depending on a variable...? =indirect("M"&a1) if A1 contained N) In code: dim N as long msgbox activesheet.range("M"&n).value 'or msgbox activesheet.cells(n,"M").value john wrote: How can I designate in a formula a cell regarding to a variable (e.g. M(value of n) is the cell M535 if n=535 ) thank you , John -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple question | New Users to Excel | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| simple vba question | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| simple question, hopefully a simple answer! | Excel Programming | |||
Hybrid Mode
