embedding a formula

Hi Guys

Can this be done:

I need to embed a formula in a cell so that the value is calculated automatically, but with the option of over writing the value but not loosing the original formula.

Does this make sense ?

cheers

Hi

If it makes any sense depends on the purpose.
But if you link the macro below to a button it can be done.

Please Login or Register  to view this content.

Regards

Piet

Thank you,

I like that

cheers

stephen

Originally Posted by ptilders

Hi

If it makes any sense depends on the purpose.
But if you link the macro below to a button it can be done.

Please Login or Register  to view this content.

Regards

Piet

Hi Piet

Could you explain the formula FormulaR1C1 = "=R[-4]C[-3]+R[-4]C[-2]"

cheers

R = Row
(-4) = number of rows away from the original (5)
C = Column
(-3) = number of columns away from the original (D)

etc.

Regards Piet

thank you