LET command

[Bill Ridgeway]

Some while ago, when using Lotus 1-2-3, it was possible to force a value
into a cell by the command -

LET{cell reference}={value}

of which I don't see an equivalent in Excel.

IF this is correct THEN please let me know ELSE let me know how it may be
done.

Thanks.

Bill Ridgeway

 

[Norman Jones]

Hi Bill,

I know nothing of Lotus, but possibly:


Range("A1") = 100

 

[Bill Ridgeway]

Thanks.

That's OK in a macro. I was thinking of a formulae in a cell writing a
value to another cell. Can that be done?

Regards

Bill Ridgeway

 

[Otto Moehrbach]

No it can't be done. A formula in a cell can return a value to only that
cell. HTH Otto