Controlling a cell in a worksheet

[Michael Singmin]

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

 

[Juan Pablo González]

No, a function can only return a value, not modify "other" cells, except
itself...

 

[keepITcool]

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]

Mhm... maybe, but the VBA code puts "Lotus" in C6..., hence my comment.
(Unless the OP puts ="Lotus" in C6 <g> )

 

[keepITcool]

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 >

 

[Michael Singmin]

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
=======================================================