Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling a cell in a worksheet
Hello group,
This time, going from VBA to the worksheet. In the cell F13 is $C$6 Range(Range("F13")) = "Lotus" results in C6 getting the value Lotus Can this be done in a worksheet ? Can one put in A1 some code that will do the same ? Thanks, Michael Singmin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling a cell in a worksheet
No, a function can only return a value, not modify "other" cells, except
itself... -- Regards Juan Pablo González "Michael Singmin" wrote in message ... Hello group, This time, going from VBA to the worksheet. In the cell F13 is $C$6 Range(Range("F13")) = "Lotus" results in C6 getting the value Lotus Can this be done in a worksheet ? Can one put in A1 some code that will do the same ? Thanks, Michael Singmin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling a cell in a worksheet
I think OP measn something different.
cell a1 contains the string "c6" cell c6 contains "Lotus" formula =indirect(a1) will result in "Lotus" keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Juan Pablo González" wrote: No, a function can only return a value, not modify "other" cells, except itself... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling a cell in a worksheet
Mhm... maybe, but the VBA code puts "Lotus" in C6..., hence my comment.
(Unless the OP puts ="Lotus" in C6 <g ) -- Regards Juan Pablo González "keepITcool" wrote in message ... I think OP measn something different. cell a1 contains the string "c6" cell c6 contains "Lotus" formula =indirect(a1) will result in "Lotus" keepITcool |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling a cell in a worksheet
oops :) just saw the Range(Range() construct...
and was misled by the OP's phrase 'results in C6 getting' to OP: it's like Juan says... 'it can pull but it cant push' keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Juan Pablo González" wrote: Mhm... maybe, but the VBA code puts "Lotus" in C6..., hence my comment. (Unless the OP puts ="Lotus" in C6 <g ) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling a cell in a worksheet
Thank you for the discussion,
I like the rule: Pull but not Push Btw, John Walkenbach proves otherwise for special cases. http://j-walk.com/ss/excel/odd/odd06.htm Cheers, Michael Singmin ================================================== ===== keepITcool wrote: oops :) just saw the Range(Range() construct... and was misled by the OP's phrase 'results in C6 getting' to OP: it's like Juan says... 'it can pull but it cant push' keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Juan Pablo González" wrote: Mhm... maybe, but the VBA code puts "Lotus" in C6..., hence my comment. (Unless the OP puts ="Lotus" in C6 <g ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controlling word wrap in a cell | Excel Discussion (Misc queries) | |||
Controlling which cell you go to when Tab is entered | Excel Discussion (Misc queries) | |||
Controlling text in an Excel worksheet | Excel Worksheet Functions | |||
Controlling Cell/Cursor Placement | Excel Discussion (Misc queries) | |||
controlling cell borders in excel using VB | Excel Programming |